Timing on the workers

[Linda]

Hi Erman!
Upgrading from 12.1.3->12.2.6 now :)
Do you have good select to find out which  run of adworker sqls take long time during the upgrade ?
I could then tune those  /search in Metalink...

I had before  this:
select TRUNC(t.ELAPSED_TIME * 24 * 60) MINUTES,
       t.PROGRAM_RUN_ID,
       t.job_name,
       t.product,
       t.worker_id,
       t.phase,
       t.phase_name,
       t.arguments,
       t.start_time,
       t.end_time,
       t.subdirectory,
       t.command
  from applsys.AD_PROGRAM_RUN_TASK_JOBS t
 WHERE start_time > sysdate -10
 ORDER BY ELAPSED_TIME DESC;
 
But now its not containing the details anymore .. Just prio patch u10124646.drv ( merged with others)

Thanks,Linda

[ErmanArslansOracleBlog]

Hi Linda,

Check this;

Express Diagnosis of Oracle E-Business Suite Release 12 Upgrade Performance Issues (Doc ID 1583752.1)

In that note, you will find a pdf file attached . (Express Diagnosis of Oracle E-Business Suite Release 12 Upgrade Performance Issues(207.52 KB)) Check it , it can help you.
Especially, the section named : During the Oracle E-Business Suite Upgrade...