Oracle-L: RE: cant set multiblock read count

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 12 Nov 2002 04:33:57 -0800
Message-ID: <F001.00500C76.20021112043357@fatcity.com>

Rahul

Check out http://www.ixora.com.au/tips/max_multiblock_read.htm Steve Adams mentions "The first trap to be aware of is that Oracle does not complain about attempts to set the multiblock read count to values that are larger than the maximum value allowed under the operating system"

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, November 12, 2002 3:11 AM To: Multiple recipients of list ORACLE-L

list !!
my ora7.3.2 instance on AIX with a db_block_size of 4k has a multi block read count of 16 !!

i thought i would create a new instance with a block size of 8k, so i can set
the max multiblock read count to more than 16, BUT, after creating the new instance
the db_multiblock_read_count *always* defaults to 8 !!

here the new instance params

db_files = 16
db_file_multiblock_read_count = 32
db_block_buffers = 3840
db_file_simultaneous_writes = 8
db_block_lru_latches = 8

shared_pool_size = 31457280

which of these parameter is affecting the value of multiblock read count ???

TIA
Rahul

PS: i hv checked the multiblock reads using ixora script... always 8 !!

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Rahul
INET: rahul_at_ratelindo.co.id

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

RE: cant set multiblock read count > 8 !!!