To 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 ...
To 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 ...
Apex 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 ...
Installation 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. ...
Apex 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 ...
Concurrent 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). ...
Start Tuning….
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 ...
Apps User who are assigned a particular responsibility
— 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 ...
List Responsibilities That Can Run a Given Concurrent Program
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 ...