SQL Script with HTML Formated Output download here
The voice in my head may not be real , but they have some good ideas !!!
Fail Fast, Fail Forward, Fail Often, Fail Better , Standup Every Time
Every problem has at least one solution. Only some solutions are harder to find.
Monday, July 2, 2007
EBS : Concurrent Queue Analysis
This script will help Application Database Administrator to get Concurrent Queue and the total number of requests processed. Also this report has an hourly map of the top three requests.

SQL Script with HTML Formated Output download here
SQL Script with HTML Formated Output download here
EBS : Concurrent Request's High Impact Concurrent Programs
This script will help Application Database Administrator to get Concurrent Request's High Impact Concurrent Programs
Sample Data :

SQL Script with HTML Formated Output download here
Sample Data :
SQL Script with HTML Formated Output download here
EBS : Concurrent Request's High Frequency Concurrent Programs
This script will help Application Database Administrator to get Concurrent Request's High Frequency Concurrent Programs
Sample Data :

SQL Script with HTML Formated Output download here
Sample Data :
SQL Script with HTML Formated Output download here
EBS : Concurrent Request Daily Run Analysis
This script will help Application Database Administrator to get Concurrent Request Daily Run Analysis View.
Sample Output:

SQL Script with HTML Formated Output download here
Sample Output:
SQL Script with HTML Formated Output download here
EBS : Concurrent Request Map View
This script will help Application Database Administrator to get Concurrent Request Map View.
Sample Output:

SQL Script with HTML Formated Output download here
Sample Output:
SQL Script with HTML Formated Output download here
EBS : Concurrent Request with highest average run times
This script will help Application Database Administrator to get Concurrent Request with highest average run time.
Sample Output:

SQL Script with HTML Formated Output download here
Sample Output:
SQL Script with HTML Formated Output download here
Subscribe to:
Posts (Atom)
Popular Posts
-
Big Data Oracle NoSQL in No Time - It is time to Upgrade Oracle NoSQL upgrade from 11gR2 to 12cR1 ( 2.0 to 3.0 ) Index Big Data Oracl...
-
Grafana for OCI Monitoring in Docker on Windows Step 1: Install Docker Desktop on Windows https://docs.docker.com/docker-for-windows/inst...
-
[oracle@testebsop3app01 ~]$ perl /u01/install/APPS/fs1/EBSapps/comn/clone/bin/adcfgclone.pl appltop /u01/install/APPS/fs1/inst/apps/SATURN_...
-
Unleashing the Power of AI Within Your Oracle Database: Introducing oracle_ai_plsql_agent The world of Artificial Intelligence (AI) is rapi...
-
Suddenly all production reports in BI Publisher failed with message " ORA-01017: invalid username/password; logon denied" The da...
-
PRVG-2031 : Owner of file "/u01/app/oracle/diag/crs/rac01/crs/lck" did not match the expected value on node "HOST1". [Ex...
-
FS_CLONE Phase It is a stand-alone command used for file system cloning. Standard cloning (using adcfgclone.pl) cannot be used to synch...
-
If you are an EBS administrator the first thing some asks you to do a health check of an environment , you return to him with a Request ID o...
-
Abort Phase If for some reason either the prepare or apply phase failed or gave problems, you can abort the patching cycle. After runnin...
-
EBS 12.2 ADOP SQL to Find Session Details A Simple and Useful SQL to find the list of Patches and Actions that are performed in each Patchi...