Is DBFMRC limited to 16 on AIX ?
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 04 Aug 2008 22:51:40 +0800
Testing db_file_multiblock_read_count at 128 on AIX we found much
poorer performance (higher read times of 35ms) then that for dbfmrc
at 16 (3ms).
One of the team (not from Oracle) referred us to this section
(A.2.5) of the Oracle Database Administrator's Reference for Unix
http://download.oracle.com/docs/cd/B19306_01/server.102/b15658/appa_aix.htm#sthref792
"Setting a large value for the DB_FILE_MULTIBLOCK_READ_COUNT
initialization parameter usually yields better I/O throughput on
sequential scans. On AIX, this parameter ranges from 1 to 512, but
using a value higher than 16 usually does not provide additional
performance gain.".
How did Oracle come up with this limit of 16 for AIX ?
Is it only for for DIO / CIO or NOT for DIO / CIO ?
What experiences do Oracle on AIX administrators have with dbfmrc ?
Hemant K Chitale
http://hemantoracledba.blogspot.com
"A 'No' uttered from the deepest conviction is better than a 'Yes'
merely uttered to please, or worse, to avoid trouble."
Mohandas Gandhi Quotes
: http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html
--
//www.freelists.org/webpage/oracle-l
Other related posts:
