檢視當前使用者正在等待事件

Select distinct
a.sql_text,b.event,b.logon_time,b.username,a.CPU_TIME/1000/a.executions "cpu
ms",b.event#,b.sid,b.serial#,b.service_name,b.module "應用程式" ,c.value,d.name
from v$sqlarea
a,v$session b,V$SESStat c,v$statname d where a.sql_id=b.sql_id and b.sid=c.sid and c.STATISTIC# =
d.STATISTIC# and b.status = 'ACTIVE' and  b.event not in('SQL*Net message from client','SQL*Net message to
client','SQL*Net more data
to client','client message','virtual circuit
status','parallel query idle
wait - Slaves',' parallel query
dequeue wait','lock element
cleanup','dispatcher timer','pmon timer- pmon','rdbms ipc message','Space Manager:
slave idle wait') order by b.logon_time desc;