Didi you have multiple sessions executing the
statement multiple times ? I had to use a minimum
of 3 sessions running the query about 4 times in a
row to make this happen using source$. You may need
more sessions and more passes - or may even need
to construct a very large table - depending on the size
of your db_block_buffer, available memory, and number
of CPUs.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Now running 3-day intensive seminars
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Ted Chyn wrote in message
<44a19320.0202040748.410e1409_at_posting.google.com>...
>kyle, I tried your example
>select count(*) from $source and the wait in trace file were
>'db file sequential read' other than 'buffer block wait' ?
>
>thnx
>ted
Received on Tue Feb 05 2002 - 15:28:09 CST
