Oracle A423961 Manual Do Utilizador
C – 3
Initialization Parameter Files
The annotated, sample initialization parameter file contains alternative
values for the initialization parameters. These values and the
annotations are preceded by comment signs (#), which prevent them
from being processed. To activate a particular parameter, remove the
preceding # sign. When you no longer want to use a particular
parameter, edit the initialization parameter file to add a comment sign.
values for the initialization parameters. These values and the
annotations are preceded by comment signs (#), which prevent them
from being processed. To activate a particular parameter, remove the
preceding # sign. When you no longer want to use a particular
parameter, edit the initialization parameter file to add a comment sign.
For example, several initialization parameters are specified with three
different values to create small, medium, or large System Global Areas
(SGAs), respectively. By default, the parameter that would create a small
SGA is active, as in:
different values to create small, medium, or large System Global Areas
(SGAs), respectively. By default, the parameter that would create a small
SGA is active, as in:
db_block_buffers = 200
# SMALL
# db_block_buffers = 550
# MEDIUM
# db_block_buffers = 3200
# LARGE
If you wish to create a medium–sized SGA instead, comment out the
small parameter definition, and activate the medium. In the previous
example, you would change file to read:
small parameter definition, and activate the medium. In the previous
example, you would change file to read:
# db_block_buffers = 200
# SMALL
db_block_buffers = 550
# MEDIUM
# db_block_buffers = 3200
# LARGE
Parameters to Modify when Creating a New Database
Check the initialization parameters described in this section carefully at
the time you create a new database; they cannot be modified after you
have created the database. (See Chapter 3 of this Guide for details on
creating a new database, including the part of the procedure when you
modify these parameters.)
the time you create a new database; they cannot be modified after you
have created the database. (See Chapter 3 of this Guide for details on
creating a new database, including the part of the procedure when you
modify these parameters.)
DB_NAME
Specifies the name of the database to be created. The database name is a
string of eight characters or less. You cannot change the name of a
database.
string of eight characters or less. You cannot change the name of a
database.
CHARACTER_SET
Specifies the database NLS character set to use. This parameter can be
set only when you create the database.
set only when you create the database.
CONTROL_FILES
Designates the names and locations of all control files to be created and
maintained. By default, Oracle7 Server for Windows NT installs a single
maintained. By default, Oracle7 Server for Windows NT installs a single