Re: SQL IO Disk Reads

        In all probability Oracle will read no more than one data read to fetch both rows.

        Oracle reads multiple OS disk blocks at a time. The number of bytes read can be found by multiplying the size of the data base block buffer by the number of blocks read. Once data is read it stays in the block buffer ares until it is flushed out - which happens when all of the blocks in the buffer are filled, one or more blocks have to be read into the buffer, and the block in question is the Least Recently Used block.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 5/25/00, 11:42:18 AM, "Paul" <paul_at_yeahright.com> wrote regarding SQL  

IO Disk Reads:

> Does SQL extract records per page or or per item in a page. e.g.
> If I had 2 record per page, in general, would the number of IO's be
 one IO
> for every two records or two IO's for two records?
> Cheers
Received on Fri May 26 2000 - 00:00:00 CDT