Saturday, June 25, 2011

Wait event session detail

select sid,serial#,module,action,sql_address from v$session where sid in (select sid from v$session_wait
where event like 'db file scattered read')

if you want session information of other wait event then you mention wait event name on replace of db file scattered read.

No comments:

Post a Comment