Namespace prefix ‘crosstab’ used but not declared
Report Completed with Warning which shows the OPP error in the log file in R12.1.1 Scenario ======== When we tried to run an cutom report using RTF we get the…
Read MoreSQLTXPLAIN
What is SQLTXPLAIN (SQLT)? Ø SQLTXPLAIN is tool to enable users to analyze and tune the performance of a single SQL statement. Ø SQLTXPLAIN, also known as SQLT. SQLT inputs one SQL statement and outputs a set of diagnostics files. These files are commonly used to diagnose SQL statements performing poorly. SQLT connects to the database and collects execution plans, Cost-based Optimizer CBO statistics, schema objects metadata, performance statistics, configuration parameters, and similar elements that influence the performance of the SQL being analyzed. Installing the Utility 1.Download the file sqlt.zip file from Note 215187.1 and unzip it to an empty local or server directory. This will create the “sqlt” directory and a number of subdirectories. 2.In the sqlt/install directory run the script “sqcreate.sql” Navigate to the sqlt/install directory $sqlplus ‘/as sysdba’ Sql>START sqcreate.sql During the installation you will be asked to enter values for these parameters: 1.Optional Connect Identifier. In some restricted-access systems you may need to specify a connect identifier like @PROD. If a connect identifier is not needed, enter nothing and just hit the “Enter” key. Entering nothing is the most common setup. 2.SQLTXPLAIN password. Case sensitive in most systems. 3.SQLTXPLAIN Default Tablespace. Select from a list of available permanent tablespaces which one should be used by SQLTXPLAIN for the SQLT repository. It must have more than 50MB of free space. 4.SQLTXPLAIN Temporary Tablespace. Select from a list of available temporary tablespaces which one should be used by SQLTXPLAIN for volatile operations and objects. 5.Optional Application User. This is the user that issued the SQL statement to be analyzed. For example:- If this were an EBS system specify APPS, on Siebel you would specify SIEBEL and on People Soft SYSADM. You won’t be asked to enter the password for this user. You can add additional SQLT users after the tool is installed, by granting them role SQLT_USER_ROLE. 6.Licensed Oracle Pack. (T, D or N) You can specify T for Oracle Tuning, D for Oracle Diagnostic or N for none. If T or D is selected, SQLT may include licensed content within the diagnostics files it produces. Default is T. If N is selected, SQLT installs with limited functionality Note: 2 users and one role are created. These users and role have fixed names Users:-SQLTXADMIN,SQLTXADMIN Role:- SQLT_USER_ROLE Privileges Required:– The SQLT repository is owned by user SQLTXPLAIN. SQLT users need to provide the SQLTXPLAIN password everytime they use any of the main methods. User SQLTXPLAIN is granted the following system privileges: •CREATE SESSION •CREATE TABLE The SQLT set of PL/SQL packages and Views is owned by user SQLTXADMIN. This SQLTXADMIN user is locked and identified by a random password. SQLTXADMIN is granted the following system privileges:…
Read MoreREP-3000: Internal error starting Oracle Toolkit
Scenario: ========= Active Users concurrent request Errored out. Log file shows the following error: ================================== APPLLCSP Environment Variable set to : Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are : American_America.UTF8…
Read MoreInstallation of Oracle Database Express Edition 11g Release 2 on RHEL5 (Red Hat Enterprise Linux ) using VMware Workstation
Oracle Database Express Edition Docs
Read MoreOracle 12c R1 Released Officially
Content From Oracle Press Release Oracle Announces General Availability of Oracle Database 12c, the First Database Designed for the CloudREDWOOD SHORES, Calif. – July 1, 2013 News…
Read MoreScript to check AD Jobs which runs more than 60mins
set lines 170 set pages 1000 select distinct t.job_name, TRUNC(t.ELAPSED_TIME * 24 * 60) MINUTES, t.PROGRAM_RUN_ID, t.product, t.start_time,…
Read MoreExtension function error: Method not found ‘xdo_format_currency’
Scenario : ======== After the upgrade from 12.0.4 to 12.1.3 the custom reports are completed with warning and the request log file show there was an error in OPP and…
Read MoreRole of APPLSYSPUB, GUEST, APPLSYS, APPS users
Role of APPLSYSPUB, GUEST, APPLSYS, APPS users APPLSYSPUB user/schema in Oracle Applications: When we login to applications, initially oracle applications connect to public schema, APPLSYSPUB. This schema has sufficient privileges…
Read MoreApex Users Login’s details
select WORKSPACE,APEX_USER,PAGE_NAME, trunc(VIEW_DATE) “Date”, VIEW_DATE from APEX_040100.APEX_WORKSPACE_ACTIVITY_LOG Where workspace in (‘DOYEN’) AND trunc(view_date) = trunc(sysdate-1) –and TRUNC(view_date) BETWEEN :From_date AND :TO_DATE and page_name not in (‘Page 1′,’zero’,’Oracle Application Express’,’Login’,’Application Builder’)…
Read More