Database Tuning (MOSC)

MOSC Banner

Is DB_FILE_MULTIBLOCK_READ_COUNT deprecated?

edited Jun 29, 2016 3:25PM in Database Tuning (MOSC) 4 commentsAnswered ✓

In our database we experience Wait Class Evente User I/O and most of our events are: index fast full scan, db file sequential read, I have read a way to avoid these events is unseating the parameter  DB_FILE_MULTIBLOCK_READ_COUNT because It's and deprecated parameter, but when we unset it and after re start the database  this parameter still set. but I can't find a official doc or paper that confirm this about the parameter.

how we try to unset this parameter:

SQL> alter system reset db_file_multiblock_read_count scope=spfile sid='*';
System altered.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center