ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN A6A099DE9A1DD29AE053B46B63580FE7Y with buckets as ( select :date_from + numtodsinterval(:n * (level - 1), :metric) from_bucket, :date_from + numtodsinterval(:n * level, :metric) to_bucket from dual connect by level <= ((:date_to - :date_from + 1) * decode(:metric,'DAY',1,'HOUR',24,'MINUTE',60*24)/:n) + 1) select r.from_bucket, r.to_bucket, r.n, lpad('-',ceil((r.n / nullif(max(r.n) over (),0)) * 100),'-') chart from ( select b.from_bucket, b.to_bucket, count(r.request_id) n from buckets b left join (select r.request_id, r.actual_start_date, r.actual_completion_date from fnd_concurrent_requests r join fnd_concurrent_processes p on p.concurrent_process_id = r.controlling_manager join fnd_concurrent_queues q on q.concurrent_queue_id = p.concurrent_queue_id where q.concurrent_queue_name = :conc_queue or :conc_queue is null) r on r.actual_start_date < b.to_bucket and r.actual_completion_date >= b.from_bucket where b.to_bucket <= sysdate group by b.from_bucket, b.to_bucket) r order by r.from_bucket desc US Concurrent Requests Bucketed Displays a the number of concurrent requests running within specified time buckets. :conc_queue :date_from :date_to :metric :n 1 10 :date_from Date Y US Date From 2 20 :date_to Date Y US Date To 3 30 :metric LOV custom Y select 'MINUTE' value, 'Minute' description from dual union all select 'HOUR' value, 'Hour' description from dual union all select 'DAY' value, 'Day' description from dual Y US Time Metric 4 40 :n Number Y US Metric Interval 5 50 :conc_queue LOV custom Y select concurrent_queue_name value, user_Concurrent_queue_name description from fnd_concurrent_queues_vl order by description STANDARD US Concurrent Manager