select /*+ ordered */
distinct sw.event,
sw.sid,
s.KSUUDNAM username,
s.KSUSEPNM program,
-- sw.state, sw.seconds_in_wait seconds,
sw.state,
sw.wait_time seconds,
sw.p1,
sw.p2,
sw.p3,
sa.kglnaobj last_sql
from sys.v$session_wait sw, sys.x$ksuse s, sys.x$kglob sa
where sw.event not in ('rdbms ipc message',
'smon timer',
'pmon timer',
'SQL*Net message from client',
'SQL*Net message to client',
'lock manager wait for remote message',
'ges remote message',
'client message',
'SQL*Net more data from client',
'pipe get',
'Null event',
'PX Idle Wait',
'single-task message',
'wakeup time manager')
and s.KSUUDNAM <> 'SYS'
and (sw.sid = s.KSUSENUM)
and (s.KSUSESQH = sa.KGLNAHSH)
order by sw.event, sw.sid
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/18900329/viewspace-1743641/，如需转载，请注明出处，否则将追究法律责任。
| 
转播
