In Oracle : Timing Reports in Oracle 11i (adtimrpt)

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Applications EBS

Oracle Apps 11i DBA (I) Oracle Apps 11i DBA (II) Oracle Apps 11i DBA (III) Oracle Apps 11i Sys Admin UPGRADE 11i Apps to R12 Oracle Apps R12 DBA

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle Applications (apps)  -> 11i

-> adtimrpt: Timing Reports in Oracle 11i

 

 adtimrpt: Timing Reports in Oracle 11i

 

 

1. What are the Timing Reports ?

2. How could I create a Timing Report ?

3. How could I read the Timing Report for the execution of a particular AD Job ?

 

 

1. What are the Timing Reports ?

 

The Timing Reports are statistics about the execution of the AD utilities which use parallel workers (AD Admin, AutoUpgrade, AutoPatch). 

 

2. How could I create a Timing Report ?

 

AD utilities, by default, create such a report of the end of the execution. However, such a report could be created before the AD utility completes, by running $AD_TOP/admin/sql/adtimrpt.sql script and provide the session identifier as parameter.  

 

 

3. How could I read the Timing Report for the execution of a particular AD Job ?

  1. By reading the adt<session ID>.lst file which is generated automatically by the AD utility in the $APPL_TOP/admin/<SID>/out directory.


      Here are some information we can find the the AD Jobs Timing Reports:

 

adtimrpt: Timing Reports in Oracle Apps



adtimrpt: Timing Reports in Oracle Apps

 

  1. By using Oracle Application Manager

   a) Logon to Oracle Applications Manager as sysadmin 

 

   b) click on "Site Map" -> "Maintenance" -> "Timing Reports"

 

   adtimrpt: Timing Reports in Oracle Apps

 

   For more details on a particular AD Job execution click on "Details" icon.

 

adtimrpt: Timing Reports in Oracle Apps

 

adtimrpt: Timing Reports in Oracle Apps

 

 

 

In-Oracle.com  -> Oracle Applications (apps)  -> 11i 

-> adtimrpt: Timing Reports in Oracle 11i

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.