Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DB_FILE_MULTIBLOCK_READ_COUNT question

DB_FILE_MULTIBLOCK_READ_COUNT question

From: Michael J. Moore <mNiOcShPaAeMl.j.moore_at_wcom.com>
Date: Fri, 15 Sep 2000 21:55:58 GMT
Message-ID: <OVww5.1156$6a1.19316@pm01news.wcom.com>

In the Oracle 8i DBA Handbook I am reading on page 335.:

"The number of blocks read at a time is limited by the I/O buffer size of your operating system."

The DB_BLOCKSIZE paramater in the init.ora is 8192 which means that the OS has an 8k disk block size (assuming that the DBA who set the parameter knew the disk block size and set a 1 to 1 ratio).

But, what is the I/O buffer size of my OS. I am running Solaris on a Sun Enterprise II. Is there a command that I can type that will tell me what the I/O block size is?

thanks,
Mike Received on Fri Sep 15 2000 - 16:55:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US