RE: db_file_multiblock_read_count 10g default values

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Thu, 5 Nov 2009 15:33:12 -0700
Message-ID: <64BAF54438380142A0BF94A23224A31E112E73A025_at_ONEWS06.oneneck.corp>

After a little more fiddling, it looks like the formula is calculated at instance startup as:

db_file_multiblock_read_count = db_cache_size/processes/9600, with a max of .28% of the db_cache_size

I'm not sure where that constant 9600 comes from, but I'd guess it's based on db_block_size (8192 in my case) plus some other overhead.

Regards,
Brandon

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 05 2009 - 16:33:12 CST