Re: db file sequential read - again

At 07:35 AM 3/13/2007, jherrick@xxxxxxx wrote:
"db file sequential reads" are single block reads and therefore can target data blocks as well as index bocks. "db file scattered reads" are multi-block reads and therefore can target index blocks as well as data blocks. 



- Can somebody re-explain this please?

using any index it finds (which we all know could be a bad thing!). I'm
thinking of putting hot indexes into their own buffer pool since I've got tons
of memory. Does this sound like a reasonable approach to you folks?
What is your rationale of putting "hot indexes" into their own pool? What are you trying to accomplish with this? 


Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com 


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: