EBS 单实例上所有正在运行的并发请求以及请求目前的状态

hx0011yy

---一个实例上运行的所有并发请求的总结和他们目前的状态以及等待状态
select w.seconds_in_wait "Secondswait",
w.event "waitEvent",
w.p1 || chr(10) || w.p2 || chr(10) || w.p3 "Session Wait",
p.spid || chr(10) || s.process "ServerClient",
s.sid || chr(10) || s.serial# || chr(10) || s.sql_hash_value "SidSerialSQLHash",
u.user_name || chr(10) || PHASE_CODE || ' ' || STATUS_CODE ||
chr(10) || s.status "DBPhaseStatusCODEUser",
Request_id || chr(10) || priority_request_id || chr(10) ||
Parent_request_id "Request_id",
concurrent_program_name,
user_concurrent_program_name,
requested_start_Date || chr(10) ||
round((sysdate - requested_start_date) * 1440, 2) || 'M' "RequestStartDate",
ARGUMENT_TEXT,
CONCURRENT_QUEUE_ID,
QUEUE_DESCRIPTION
FROM FND_CONCURRENT_WORKER_REQUESTS,
fnd_user                       u,
gv$session                      s,
gv$process                      p,
gv$session_wait                 w
WHERE (Phase_Code = 'R')
and hold_flag != 'Y'
and Requested_Start_Date <= SYSDATE
AND ('' IS NULL OR
('' = 'B' AND PHASE_CODE = 'R' AND STATUS_CODE IN ('I', 'Q')))
and '1' in (0, 1, 4)
and requested_by = u.user_id
and s.paddr = p.addr
and s.sid = w.sid
and oracle_process_id = p.spid
and oracle_session_id = s.audsid
order by requested_start_date;