Step 5 - Viewing and Modifying Initialization Parameters
Learn Oracle - Viewing and Modifying Initialization Parameters
When Oracle DBA install one of the preconfigured databases provided by Oracle, the
initialization parameters are optimized for normal use in the environment that Oracle DBA
specified. It is not necessary for Oracle DBA to alter any initialization parameters at this time.
The steps described in this section will familiarize you with the initial parameter
setting for your database and indicate how to modify parameters.
To view or modify the initialization parameters for your database:
1. From the Database Home page, click the Administration property page.
2. Click All Initialization Parameters under the Instance heading.
Enterprise Manager displays the Initialization Parameters page comprised of a
table listing the current value of each initialization parameter as seen by the
database instance. Oracle DBA can also use this page to alter initialization parameter
values, using the Show SQL, Revert, and Apply buttons.
There are two property pages shown on the Initialization Parameters page:
Current—The table on this property page displays all of the initialization
parameter values currently seen by the database instance (in memory).
Oracle DBA can use this page to make dynamic changes to parameters in the current
running instance. Only parameters marked dynamic can be changed. To do so,
enter a new value and click Apply.
This property page is present when Oracle DBA are using a server parameter
file, whose location is displayed a the top of the table. This property page
shows parameter settings in the server parameter file.
Changes to parameter settings in this file are persistent across instance startup
and shutdown. To make persistent changes to an initialization parameter,
enter the new value and click Apply. Oracle DBA can optionally apply changes to the
current running instance by checking Apply changes in SPFile to the current
running instance. If you do not check this box, your changes will not take effect
until the database is shut down and restarted.
As the number of database users grows and workload increases, Oracle DBA might need
to alter some initialization parameters. You can make these changes directly using
the Initialization Parameter page as described, or indirectly using one of the
advisors provided by Oracle.