"EscVector" <Junk@webthere.com> wrote in message
news:1168531840.130757.22890@77g2000hsv.googlegrou ps.com...
> I'm bottlenecked on db file sequential read. What wait should I expect
> to see if the plan shows Index Fast Full Scan? Is it db file
> sequential read or scattered read since the Fast Full Scan is treated
> like a tablescan and uses multiblock reads?
>

Typically "db file scattered read"
see
http://jonathanlewis.wordpress.com/2...ex-operations/

--
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html