1* select * from v$sysstat where lower(name) like '%table%'
ops$tkyte@ORA8I.WORLD> /

STATISTIC# NAME CLASS VALUE
---------- ------------------------------ ---------- ----------
48 DBWR transaction table writes 8 614
144 transaction tables consistent 128 0
reads - undo records applied

145 transaction tables consistent 128 0
read rollbacks

158 table scans (short tables) 64 1676475
159 table scans (long tables) 64 3942
160 table scans (rowid ranges) 64 0
161 table scans (cache partitions) 64 7153
162 table scans (direct read) 64 0
163 table scan rows gotten 64 1512068438
164 table scan blocks gotten 64 24283078
165 table fetch by rowid 64 22813564
166 table fetch continued row 64 309293


1* select * from v$sysstat where lower(name) like '%full%'
ops$tkyte@ORA8I.WORLD> /

STATISTIC# NAME CLASS VALUE
---------- ------------------------------ ---------- ----------
76 commit cleanouts successfully 8 268320
completed

174 index fast full scans (full) 64 10981
175 index fast full scans (rowid r 64 0
anges)

176 index fast full scans (direct 64 0
read)


will get that. You do not need timed_stats however, i would recommend you just leave it on, it is so useful.


I use statspack to find the "top offenders" as far as SQL goes. Goto asktom.oracle.com/magazine-archive.htm and search for statspack for a couple of articles on this utility.