Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Multiblock Read Count
On Fri, 23 May 2003 14:37:26 +0000, BRob wrote:
>
> 1* select name,value from v$parameter where name =
> 'db_file_multiblock_read_count'
>
> NAME VALUE
> --------------------------------
> --------------------------------------------
> db_file_multiblock_read_count 8
>
> I wonder if it has something to do with file system i/o versus
> direct i/o
>
> --
> Posted via http://dbforums.com
If you look at steve adams site and search for multiblock read count
he explains the subtle differences . But if you set your
mbrc to say for example 32 , then oracle should request to read 32 blocks at a
time for full scans to the OS . The underlying os may not do direct
i/o but buffered i/o and break that read request into chunks .
http://www.ixora.com.au
Received on Fri May 23 2003 - 11:37:17 CDT