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

John.Hallas_at_vodafone.co.uk 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: rahul_at_ratelindo.co.id
>

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: sfaroult_at_oriole.com

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).