Wednesday, January 05, 2011

Query to find the program which does sequential log file read

select
ses.program
from
v$session_event sev,
V$session ses
where
sev.event = 'log file sequential read'
and ses.sid = sev.sid
;

Go here for more detail.

No comments: