Report free space fragmentation
— +—————————————————————————-+ — | PURPOSE : Report free space fragmentation. | — | THIS SCRIPT MUST BE RUN AS THE SYS USER!!! …
Read MoreList all currently connected user sessions ordered by current PGA size
— +————————————————————————————-+ — | PURPOSE : List all currently connected user sessions ordered by current PGA size | — +————————————————————————————-+ SET LINESIZE 145 SET PAGESIZE 9999 COLUMN sid FORMAT 99999 …
Read MoreList all currently connected user sessions ordered by Logical I/O
— +——————————————————————————–+ — | PURPOSE : List all currently connected user sessions ordered by Logical – I/O | — +——————————————————————————–+ SET LINESIZE 145 SET PAGESIZE 9999 COLUMN sid FORMAT 99999 …
Read MoreList all currently connected user sessions ordered by CPU time.
— +—————————————————————————-+— | DATABASE : Oracle |— | PURPOSE : List all currently connected user sessions ordered by CPU time. |— +—————————————————————————-+ SET LINESIZE 145SET PAGESIZE 9999 COLUMN sid FORMAT…
Read MoreTo Identify the manager for a given concurrent program
The script given below identifies which manager is going to execute a given Concurrent program: SELECT user_concurrent_program_name, user_concurrent_queue_name FROM apps.fnd_concurrent_programs_tl fcp, apps.fnd_concurrent_queue_content fcqc, apps.fnd_concurrent_queues_tl cq WHERE fcqc.type_application_id(+) = fcp.application_id AND…
Read MoreTo identify long running concurrent requests for more than 1 hour.
# To identify the long running concurrent requests for more than 1 hour Mailid=<List of Mail ids> <Set the Environment> sqlplus -s ‘apps/<apps password><<EOF >> /usr/tmp/logli1.log spool /usr/tmp/longrunco.log set line…
Read MoreApex Listener Configuration for Apex
1) Check java version after completion of glassfish installation . /java -version 2) Go to location /oracle/glassfishv3/jdk/bin and Run ./java -jar /oracle/apex/apex.war, (where /oracle/apex/ is the location of apex listener…
Read MoreInstallation of Glassfish for configuring apex frontend
1. Download the Glassfish http://www.oracle.com/technetwork/java/javaee/downloads/java-ee-sdk-6u3-jdk-6u26-downloads-439816.html Example File name : java_ee_sdk-6u1-jdk-solaris-sparc.sh 2. Download the Apex listener : apex_listener.1.1.2 http://www.oracle.com/technetwork/developer-tools/apex-listener/downloads/index.html 3) Reset the password for APEX_040000 and apex_public_user i. Unlock the Apex…
Read MoreApex Installation for 11g Instance
Pre Installation Tasks: 1. Create Tablespace for Apex Data and Files.SQL> create tablespace apex datafile ‘//apexd01.dbf’ size 500m;Tablespace created. 2. Ensure Shared pool size is atleast 100m (suggested 250m) 3.…
Read MoreConcurrent Processing – Best Practices for Performance for Concurrent Managers in E-Business Suite
Generic Tips 1) Sleep Seconds – is the number of seconds your Concurrent manager waits between checking the list of pending concurrent requests (concurrent requests waiting to be started). Tip:…
Read More