Re: Max I/O

From: Holger.VanKoll@SWISSCOM.COM
Date: Tue Nov 26 2002 - 12:13:06 EST


http://os.cc.biu.ac.il/documentation/oracle/8.1.7_doc/unixdoc/aix.817/a8
5348/ch2.htm#731349

(non-striped 64 I think)

I assume you are talking about "DB_FILE_MULTIBLOCK_READ_COUNT"
If not, ask your dba what the parameter is called.

-----Original Message-----
From: Stephen Spalding [mailto:ssaixadm@YAHOO.COM]
Sent: Tuesday, November 26, 2002 5:12 PM
To: aix-l@Princeton.EDU
Subject: Max I/O

Hello all,

I've just recently had a DBA ask me for the 'maximum
I/O' value for a particular box. He quoted the text
from the Oracle document where this is mentioned:

"The maximum value is always less than the operating
system's maximum I/O size expressed as Oracle blocks
((max I/O size)/DB_BLOCK_SIZE). If you set this
parameter to a value greater than the maximum, Oracle
uses the maximum."

Does anyone know what this is and/or where I can find
this setting on AIX? I would imagine this would have
to do with the physical drives that the oracle
instance is installed on.

Thanks!

-Stephen Spalding

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com



This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:23 EDT