set line 200
set pages 100
col "Concurrent Manager's Name" format a60
spool comcurrent_manger_status.lst
SELECT b.USER_CONCURRENT_QUEUE_NAME AS "Concurrent Manager's Name",
a.max_processes AS "TARGET Processes",
a.running_processes AS "ACTUAL Processes",
'Mismatch' Status
FROM apps.fnd_concurrent_queues a,apps.FND_CONCURRENT_QUEUES_VL b
WHERE a.CONCURRENT_QUEUE_NAME = b.CONCURRENT_QUEUE_NAME
and a.max_processes <> a.running_processes;
SELECT b.Pending_Standby,
b.Pending_Normal,
b.name AS "Concurrent Manager's Name",
a.max_processes AS "TARGET Processes",
a.running_processes AS "ACTUAL Processes",
b.Running_Normal
FROM apps.fnd_concurrent_queues a,
( SELECT c.USER_CONCURRENT_QUEUE_NAME Name,
c.CONCURRENT_QUEUE_NAME,
SUM (
DECODE (d.PHASE_CODE,
'P', DECODE (d.STATUS_CODE, 'Q', 1, 0),
0))
Pending_Standby,
SUM (
DECODE (d.PHASE_CODE,
'P', DECODE (d.STATUS_CODE, 'I', 1, 0),
0))
Pending_Normal,
SUM (
DECODE (d.PHASE_CODE,
'R', DECODE (d.STATUS_CODE, 'R', 1, 0),
0))
Running_Normal
FROM apps.FND_CONCURRENT_QUEUES_VL c, apps.FND_CONCURRENT_WORKER_REQUESTS d
WHERE c.concurrent_queue_id = d.concurrent_queue_id
AND d.Requested_Start_Date <= SYSDATE
GROUP BY c.USER_CONCURRENT_QUEUE_NAME, c.CONCURRENT_QUEUE_NAME) b
WHERE a.CONCURRENT_QUEUE_NAME = b.CONCURRENT_QUEUE_NAME;
set pages 100
col "Concurrent Manager's Name" format a60
spool comcurrent_manger_status.lst
SELECT b.USER_CONCURRENT_QUEUE_NAME AS "Concurrent Manager's Name",
a.max_processes AS "TARGET Processes",
a.running_processes AS "ACTUAL Processes",
'Mismatch' Status
FROM apps.fnd_concurrent_queues a,apps.FND_CONCURRENT_QUEUES_VL b
WHERE a.CONCURRENT_QUEUE_NAME = b.CONCURRENT_QUEUE_NAME
and a.max_processes <> a.running_processes;
SELECT b.Pending_Standby,
b.Pending_Normal,
b.name AS "Concurrent Manager's Name",
a.max_processes AS "TARGET Processes",
a.running_processes AS "ACTUAL Processes",
b.Running_Normal
FROM apps.fnd_concurrent_queues a,
( SELECT c.USER_CONCURRENT_QUEUE_NAME Name,
c.CONCURRENT_QUEUE_NAME,
SUM (
DECODE (d.PHASE_CODE,
'P', DECODE (d.STATUS_CODE, 'Q', 1, 0),
0))
Pending_Standby,
SUM (
DECODE (d.PHASE_CODE,
'P', DECODE (d.STATUS_CODE, 'I', 1, 0),
0))
Pending_Normal,
SUM (
DECODE (d.PHASE_CODE,
'R', DECODE (d.STATUS_CODE, 'R', 1, 0),
0))
Running_Normal
FROM apps.FND_CONCURRENT_QUEUES_VL c, apps.FND_CONCURRENT_WORKER_REQUESTS d
WHERE c.concurrent_queue_id = d.concurrent_queue_id
AND d.Requested_Start_Date <= SYSDATE
GROUP BY c.USER_CONCURRENT_QUEUE_NAME, c.CONCURRENT_QUEUE_NAME) b
WHERE a.CONCURRENT_QUEUE_NAME = b.CONCURRENT_QUEUE_NAME;
No comments:
Post a Comment