查看active等待事件

set pagesize 5000 linesize 300
col sid format 9999999
col spid format a10
col s# format 99999
col username format a10
col event format a20
col machine format a20
col p123 format a25
col wt format 999
col SQL_ID for a18
col BLOCKING for a10
col status for a10
alter session set cursor_sharing=force;
SELECT /* XJ LEADING(S) FIRST_ROWS */
S.SID,
S.SERIAL# S$,
P.SPID,
SUBSTR(NVL(S.USERNAME,SUBSTR(P.PROGRAM,LENGTH(P.PROGRAM)-6)),1,10) USERNAME,
SUBSTR(S.MACHINE,1,20) MACHINE,
SUBSTR(S.EVENT,1,30) EVENT, -- 修正：EVNET -> EVENT
SUBSTR(TO_CHAR(S.P1) || '/' || TO_CHAR(S.P2) || '/' || TO_CHAR(S.P3), 1,25) P123, -- 建议显式转换
S.WAIT_TIME WT,
S.LAST_CALL_ET,
S.STATUS,
S.BLOCKING_INSTANCE || ':' || S.BLOCKING_SESSION BLOCKING,
NVL(SQL_ID,S.PREV_SQL_ID) SQL_ID
FROM V$PROCESS P, V$SESSION S
WHERE P.ADDR = S.PADDR
AND S.STATUS = 'ACTIVE'
AND P.BACKGROUND IS NULL;