Posted By

theonlyalterego on 01/21/12


Tagged

Oracle program Concurrent apps


Versions (?)

Oracle - get concurrent program runtime / eval performance


 / Published in: SQL
 

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

can be used to track Oracle Apps concurrent program performance

  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

Report this snippet  

You need to login to post a comment.