select a.sid,
a.serial#,
a.username,
a.status,
a.program,
a.machine,
c.sql_text
from v$session a, v$session_wait b, v$sql c
where a.sid = b.sid
and a.sql_hash_value = c.hash_value
and a.sql_address = c.address
and b.event like 'db file scattered read%';
版权声明:本文为博主原创文章,未经博主允许不得转载。
oracle,linux