Buscar Full Scan en los sql posteriores a su ejecucion
select
to_char(sn.begin_interval_time,’dd-mm-yyyy hh24mm’) c1 , p.object_name,p.options ,t.sql_text ,s.module from dba_hist_sql_plan p, dba_hist_sqlstat s, dba_hist_snapshot sn, dba_segments o , dba_hist_sqltext t where p.object_owner <> ’SYS’ and p.object_owner = o.owner and p.object_name = o.segment_name and o.blocks > 1000 and p.operation like ’%TABLE ACCESS%’ and p.sql_id = s.sql_id and p.sql_id= t.sql_id and s.sql_id= t.sql_id and s.snap_id = sn.snap_id and OPTIONS like ’FULL’ and to_char(sn.begin_interval_time,’dd-mm-yyyy hh24mm’)= ’08-06-2010 0706’
0 comentarios