Full table scan


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;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: