DB_FILE_MULTIBLOCK_READ_COUNT Parameter in Oracle

DB_FILE_MULTIBLOCK_READ_COUNT Parameter in Oracle

DB_FILE_MULTIBLOCK_READ_COUNT Parameter
DB_FILE_MULTIBLOCK_READ_COUNT parameter is used to specifies the maximum number of blocks read in one I/O operation during a sequential scan. If you want to scan a table, I/O has lot of dependence on the value of this parameter.
The value is mostly dependent on the Operating system.
Default value depend upon maximum I/O Size can be performed by I/O operations.

It is used to control I/O operation like fetch the number of blocks from disk to buffer cache.This parameter basically tell how many block retrieve in single I/O operations. During installation, Oracle is automatically choose the optimal value of this parameter depending on the Operating system.

Check the value of parameter

SQL> Show parameter DB_FILE_MULTIBLOCK_READ_COUNT

NAME                          TYPE    VALUE
----------------------------- ------- -----
db_file_multiblock_read_count integer 37

Change value at session or system level

-- Session Level
SQL> alter session set DB_FILE_MULTIBLOCK_READ_COUNT=128;
Session altered.

-- SYSTEM level
SQL> alter system set DB_FILE_MULTIBLOCK_READ_COUNT=128 scope=both;
System altered.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.