CONTROL_FILES Specifies the location of the control files for this instance.
DB_BLOCK_SIZE Specifies the size of Oracle blocks. This block size is used for the
SYSTEM, SYSAUX, and temporary tablespaces at database creation.
DB_CREATE_FILE_DEST The default location for OMF datafiles. Also specifies the location of
control files and redo log files if DB_CREATE_ONLINE_LOG_DEST_
n is not set.
DB_CREATE_ONLINE_LOG_DEST_n The default location for OMF control files and online redo log files.
DB_DOMAIN The logical domain name where the database resides in a distributed
database system (for example, us.oracle.com).
DB_NAME A database identifier of up to eight characters. Prepended to the
DB_DOMAIN value for a fully qualified name (for example, marketing.
us.oracle.com).
DB_RECOVERY_FILE_DEST The default location for the recovery area. Must be set along with
DB_RECOVERY_FILE_DEST_SIZE.
DB_RECOVERY_FILE_DEST_SIZE The maximum size, in bytes, for the files used for recovery in the
recovery area location.
DB_UNIQUE_NAME A globally unique name for the database. This distinguishes
databases that have the same DB_NAME within the same DB_
DOMAIN.
INSTANCE_NUMBER In a RAC installation, the instance number of this node in the cluster.
TABLE 1-3 Basic Initialization Parameters
44 Oracle Database 11g DBA Handbook
Initialization Parameter Description
JOB_QUEUE_PROCESSES The maximum number of processes allowed for executing jobs,
ranging from 0 to 1000.
Pages:
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130