Archive

Archive for the ‘Initialization Parameters’ Category

DB_BLOCK_SIZE

June 17, 2011 Leave a comment

This parameter in the init.ora is the most important. This can be done only during creation time. If you have already created the Database you cannot change this value. You will have to re-create the Database with a different size.

show parameter DB_BLOCK_SIZE;
SELECT
 name, value, display_value, description
 FROM
 v$parameter
 WHERE
 name = lower('DB_BLOCK_SIZE');