Concurrent queues

rem  fndqueue.sql

rem

ttitle 'FND Concurrent Queues'

rem

col user_concurrent_queue_name format a30 heading 'QUEUE NAME'

col manager_type format a4 heading 'TYPE'

col batch_queue format 999 heading 'BATCH|QUEUE'

col tm_queue format 99 heading 'TM|QUEUE'

col running_processes format 99 heading 'RUN|JOB'

col max_processes format 99 heading 'MAX|JOB'

col min_processes format 99 heading 'MIN|JOB'

col target_processes format 99 heading 'TARGET|JOB'

col sleep_seconds format 999 heading 'SLEEP|SECS'

col sleep_fast format a1 heading 'F'

col cache_size format 9999 heading 'CACHE|SIZE'

rem

break on report

compute sum of batch_queue tm_queue running_processes max_processes on report

rem

select qt.user_concurrent_queue_name,

       manager_type,

       decode( manager_type, '1', running_processes ) batch_queue,

       decode( manager_type, '3', running_processes ) tm_queue,

       running_processes,

       max_processes,

       min_processes,

       target_processes,

       sleep_seconds,

       decode( sleep_seconds, greatest( 30, sleep_seconds ), null, '*' ) sleep_fast,

       cache_size

  from applsys.fnd_concurrent_queues_tl qt,

       applsys.fnd_concurrent_queues q

 where q.application_id = qt.application_id

   and q.concurrent_queue_id = qt.concurrent_queue_id

   and userenv('lang') = qt.language

 order by qt.user_concurrent_queue_name;