📋Steps in this guide1/1

Find waitevents in database

select a.sid,substr(b.username,1,10) username,substr(b.osuser,1,10) osuser, substr(b.program||b.module,1,15) program,substr(b.machine,1,22) machine, a.event,a.p1,b.sql_hash_value from v$session_wait a,V$session b where b.sid=a.sid and a.event not in('SQL*Net message from client','SQL*Net message to client', 'smon timer','pmon timer') and username is not null order by 6 /

oracle configurationintermediate

by OracleDba

13 views

Find waitevents in database

Code/Command (click line numbers to comment):

select a.sid,substr(b.username,1,10) username,substr(b.osuser,1,10) osuser,
substr(b.program||b.module,1,15) program,substr(b.machine,1,22) machine,
a.event,a.p1,b.sql_hash_value
from v$session_wait a,V$session b
where b.sid=a.sid
and a.event not in('SQL*Net message from client','SQL*Net message to client',
'smon timer','pmon timer')
and username is not null
order by 6
/

Comments (0)

Please to add comments

No comments yet. Be the first to comment!