From: "Alvaro Jose Fernandez" <alvaro.fernandez@xxxxxxxxx>
To: <Amir.Hameed@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 4 Oct 2007 14:41:06 +0200
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
