SQL服务操作记录

全表扫描SQL查询：
select a.sid, a.username, b.sql_text
from sys.v_$session a, sys.v_$sqlarea b
where a.sql_hash_value=b.hash_value
and a.sid IN (select sid from sys.v_$session_wait
where event='db file scattered read') ;