Advanced Search

Oracle - get concurrent program runtime / eval performance

/ Published in: SQL
Save to your folder(s)
can be used to track Oracle Apps concurrent program performance

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT * FROM (
  2.     SELECT
  3.     f.request_id ,
  4.     pt.user_concurrent_program_name user_conc_program_name,
  5.     f.actual_start_date start_on,
  6.     f.actual_completion_date end_on,
  7. FLOOR(((nvl(f.actual_completion_date,sysdate)-f.actual_start_date)
  8.     *24*60*60)/3600)
  9.     || ' HOURS ' ||
  10.     FLOOR((((nvl(f.actual_completion_date,sysdate)-f.actual_start_date)
  11.     *24*60*60) -
  12.     FLOOR(((nvl(f.actual_completion_date,sysdate)-f.actual_start_date)
  13.     *24*60*60)/3600)*3600)/60)
  14.     || ' MINUTES ' ||
  15.     round((((nvl(f.actual_completion_date,sysdate)-f.actual_start_date)
  16.     *24*60*60) -
  17.     FLOOR(((nvl(f.actual_completion_date,sysdate)-f.actual_start_date)
  18.     *24*60*60)/3600)*3600 -
  19.     (FLOOR((((nvl(f.actual_completion_date,sysdate)-f.actual_start_date)
  20.     *24*60*60) -
  21.     FLOOR(((nvl(f.actual_completion_date,sysdate)-f.actual_start_date)
  22.     *24*60*60)/3600)*3600)/60)*60) ))
  23.     || ' SECS ' time_difference,
  24.     p.concurrent_program_name concurrent_program_name,
  25.     decode(f.phase_code,'R','Running','C','Complete',f.phase_code) Phase,
  26.     f.status_code,
  27.     fuv.description requester,
  28.     f.number_of_copies,
  29.     f.printer,
  30.     f.print_style,
  31.     f.lfile_size,
  32.     f.logfile_name,
  33.     f.ofile_size,
  34.     f.outfile_name
  35.     /* additional values*/
  36.     ,
  37.     round((f.ofile_size/1024/1024),3) ofile_mb_size,
  38.     f.argument_text params
  39.     /**/
  40.     FROM apps_fnd.fnd_concurrent_programs p,
  41.     apps_fnd.fnd_concurrent_programs_tl pt,
  42.     apps_fnd.fnd_concurrent_requests f,
  43.     apps_fnd.fnd_user_v fuv
  44.     WHERE f.concurrent_program_id = p.concurrent_program_id
  45.     AND f.program_application_id = p.application_id
  46.     AND f.concurrent_program_id = pt.concurrent_program_id
  47.     AND f.program_application_id = pt.application_id
  48.     AND pt.LANGUAGE = USERENV('Lang')
  49.     AND f.actual_start_date IS NOT NULL
  50.     AND f.requested_by = fuv.user_id
  51.     ORDER BY
  52.     f.actual_start_date DESC,
  53.     f.actual_completion_date-f.actual_start_date
  54.     ) WHERE user_conc_program_name LIKE :1

URL: http://imdjkoch.wordpress.com/2011/05/12/know-your-concurrent-programs-performance/

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.