Viewing and Modifying Initialization Parameters

Viewing and Modifying Initialization Parameters
This section provides instructions about viewing the initialization parameter settings
for your database and modifying these parameters. You can modify the initialization
parameters for the database in one of three ways:
■ Until the instance is shut down: The new values for the initialization parameters
are applied to the currently running instance, but, when the database is restarted,
the initialization parameter values revert to their previous settings.
■ From now until the initialization parameter is changed again: The changes are
applied to the currently running instance and are also stored in the server
parameter file. The changes made to the initialization parameters persist when the
database is restarted.
■ When the database is restarted: The new values for the initialization parameters
are recorded in server parameter file, but are not applied to the currently running
instance. The changes take effect only when the database is restarted.
... zobacz całą notatkę