There is a MetaLink article #131530.1 on the constant SSTIOMAX which may provide some interesting reading on this topic surround "max I/O size" and the setting of DBFMRC. The article is over 2 years old -- not sure if it pertains to 9i or above...
Wolfgang, please let us know how those 8-byte database blocks work for you, OK? on 9/11/03 8:44 PM, Wolfgang Breitling at [EMAIL PROTECTED] wrote: > db_block_size=8, db_file_multiblock_read_count = 32 > > That is a Peoplesoft ERP system, a hybrid of oltp and dss with heavy > reporting activity at month end. The dfmrc value was established through > trial and 10053 trace analysis. Some report sql still require use_hash > hints in order to avoid silly NL joins. Was looking forward to upgrading to > Oracle 9 with system statistics so that I could jack up dfmrc to the max > without nasty side-effect for the oltp part, but I'm essentially out of > that account now. > > As for finding the max operating system I/O size on windows (or any other), > just set dfmrc to some insanely high number and let Oracle figure out what > the OS wil bear. > > At 01:59 PM 9/11/2003 -0800, you wrote: >> Hello list, seeking your personal opinions and experiences about >> db_file_multiblock_read_count. >> >> What do you all set your db_block_size and db_file_multiblock_read_count >> to? >> >> How did you all come to decide that those values would suit your systems ? >> >> Any windoze user here who can tell me how can one find out the max operating >> system I/O size (on windows) in order to set db_file_multiblock_read_count ? > > Wolfgang Breitling > Oracle7, 8, 8i, 9i OCP DBA > Centrex Consulting Corporation > http://www.centrexcc.com > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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).
