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

---一个实例上运行的所有并发请求的总结和他们目前的状态以及等待状态

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;