Anto, April 30, 2010 - 3:09 pm UTC
is this correct
A reader, May 05, 2010 - 5:57 am UTC
I'm using the SQL below to find the list of segments getting full table scaned and how many times they have been full table scanned..is this SQL is correct with respect to this.
select a.obj#,a.table_scans_delta,b.object_name,b.owner,b.object_type
from dba_hist_seg_stat a, dba_objects b
where a.obj# = b.object_id
and b.owner like 'JAROS%'
order by table_scans_total desc
May 06, 2010 - 1:56 pm UTC
as long as you understand the dba_hist views are samples in general - so the number might not be *exactly* dead on - but closer than close enough...