cant set multiblock read count 8 !!!
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: cant set multiblock read count 8 !!!
Rahul, I believe there is an O/S maximum setting of this parameter to be 64K (this covers AIX and HP and and may affect others) This fits in with your finding so I am sure it is correct John -Original Message- Sent: 12 November 2002 09:11 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: cant set multiblock read count 8 !!!
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. [EMAIL PROTECTED] -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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: cant set multiblock read count 8 !!!
[EMAIL PROTECTED] wrote: Rahul, I believe there is an O/S maximum setting of this parameter to be 64K (this covers AIX and HP and and may affect others) This fits in with your finding so I am sure it is correct John -Original Message- Sent: 12 November 2002 09:11 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: [EMAIL PROTECTED] Rahul, There is an extremely interesting paper on Connor McDonald's site, http://www.oracledba.co.uk/tips/mbrc.htm -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).