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 [...]

# 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 [...]

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 [...]

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. [...]

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 [...]

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). [...]

How to Start tuning: Server Level (Focus from Oracle Database) Whenever there is server level issue, The tuning starts from the server .. Just remember the phrase “The person who has the problems [...]

— This is to list the  Apps User who are assigned a particular responsibility select a.user_name,b.responsibility_name  from fnd_user a,fnd_responsibility_vl b [...]

Purpose ——- This script helps in identifying the list of responsibilities that can run a given concurrent request REM Save this file as whocanrun.sql REM Usage: sqlplus apps/apps [...]