Re: db_file_multiblock_read_count

Another member of this list was once (possibly still is?) responsible for an application with a database whose DB_BLOCK_SIZE was set to 4608. Mind you, it was most certainly not their choice, but instead was mandated by the vendor.

The reasoning for the setting? A "very important" table in this application was deemed to have an average row width of about 4100-4500 bytes or so. The rest you can guess...

on 9/13/03 2:29 PM, Wolfgang Breitling at breitliw_at_centrexcc.com wrote:

> Great. Can keep lots of blocks in the buffer pool. Hit ratio is at 110%
> Try it out some time.
>
> At 07:49 AM 9/13/2003 -0800, you wrote:
>

>> Wolfgang, please let us know how those 8-byte database blocks work for you,
>> OK?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: tim_at_sagelogix.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).