Re: db file sequential read, where does it read to?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 2 Nov 2006 10:19:30 -0000
Message-ID: <mNSdnehRvrq3W9TYRVnyjw@bt.com>

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:Hbadncvzx99NIdTYRVnyiw_at_bt.com...
>
> "joel garry" <joel-garry_at_home.com> wrote in message
> news:1162417597.219001.165100_at_e64g2000cwd.googlegroups.com...
>>
>> You can look at what segments are in the buffer with v$bh.
>> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/memory.htm#33797
>>
>>
>
> That's a bad piece of SQL - it's inefficient and gives the
> wrong results. I've seen several "experts" present without
> attribution - I didn't realised they'd just copied it from the
> manuals
>

Pausing for thought - I suppose it's always possible that the person writing the manual copied it from one of the "experts". I wonder when it first appeared in the manuals.

-- 
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

Received on Thu Nov 02 2006 - 04:19:30 CST