My Oracle Support Banner

How To Unset DB_FILE_MULTIBLOCK_READ_COUNT to Default Value? (Doc ID 473740.1)

Last updated on MARCH 11, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.4 [Release 9.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 23-May-2016***

Goal

DB_FILE_MULTIBLOCK_READ_COUNT is set to 16 in the spfile.

How to unset the parameter as it keeps reverting back to the default value?

The documentation states:  "As of Oracle Database 10g release 2, the default value of this parameter is a value that corresponds to the maximum I/O size that can be performed efficiently. This value is platform-dependent and is 1MB for most platforms. Because the parameter is expressed in blocks, it will be set to a value that is equal to the maximum I/O size that can be performed efficiently divided by the standard block size."

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.