April 30, 2010 - 3:09 pm UTC
is this correct
May 05, 2010 - 5:57 am UTC
Reviewer: A reader
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.
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...