Is DBFMRC limited to 16 on AIX ?
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
"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
"A 'No' uttered from the deepest conviction is better than a 'Yes'
merely uttered to please, or worse, to avoid trouble." Mohandas Gandhi Quotes