Re: db file multiblock read count

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 1 Sep 2005 06:23:20 -0700
Message-ID: <1125581000.706741.5070@g44g2000cwa.googlegroups.com>

The maximum size of the db_file_multiblock_read_count parameter is Oracle version and platform port dependend.

On 10gR2 (maybe on R1) Oracle will calculate the optimal size for this parameter and adjust it on the fly if you do not manually set it.

I have seen code posted that will determine the maximum value for a platform but I do not know where I saved it (if I saved it). You might want to search the newgroup archives as I am pretty sure I saw it on either the comp.databases.oracle.server or .misc boards.

HTH -- Mark D Powell -- Received on Thu Sep 01 2005 - 08:23:20 CDT