select sysdate opdate ,g.sid sid ,g.hedef table_name , s.USERNAME username ,s.machine machine , s.module module ,a.hash_value hash_value ,a.sql_text sql_text from get_sure g ,v$session s,v$sqlarea a,v$sql_plan p where s.sid=g.SID and s.SQL_HASH_VALUE=a.HASH_VALUE and p.operation = 'TABLE ACCESS' and p.OPTIONS='FULL' and p.hash_value=a.HASH_VALUE order by hash_value;
Advertisements
