Subject: RE: DB file sequential reads 2007-10-04 - By Alvaro Jose Fernandez
Back
a quick look may be to process the trace with tkprof, but adding
"sort=fchcpu" in the command line. Odds are the d.b.f.s.r. will appear
on first-lines/top of the produced report (in my experience at least)
regards,
alvaro
>Folks,
>In a 10046 trace file taken at level 12, is there a way to find out
>which index is experiencing most of the sequential reads?
Thanks
Amir
--
http://www.freelists.org/webpage/oracle-l
|
|
