RE: DB file sequential reads

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