Saturday, October 10, 2009

Important Initialization Parameters Without Performance Impact in 10g

Necessary Initialization Parameters Without Performance Impact
==============================================================

DB_NAME := Name of the database. This should match the ORACLE_SID environment
variable.
DB_DOMAIN := Location of the database in Internet dot notation.

OPEN_CURSORS := Limit on the maximum number of cursors (active SQL
statements) for each session. The setting is
application-dependent; 500 is recommended.

CONTROL_FILES := Set to contain at least two files on different disk drives to
prevent failures from control file loss.
DB_FILES := Set to the maximum number of files that can assigned to the
database.

No comments: