查看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.EVNET,1,30) EVENT,
SUBSTR(S.P1 || '/' || S.P2 || '/' || 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;