Skip Headers
Oracle® Database 2 Day DBA
11g Release 1 (11.1)

Part Number B28301-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

Viewing and Modifying Initialization Parameters

This section provides instructions about viewing the initialization parameter settings for your database and modifying these parameters. Three scenarios are explained for modifying initialization parameters:

Note:

These three scenarios correspond to using the SCOPE=MEMORY, SCOPE=BOTH, and SCOPE=SPFILE clauses of the ALTER SYSTEM SQL statement, respectively, when you use the ALTER SYSTEM SQL statement to change initialization parameters.

To view or modify initialization parameters:

  1. At the top of the Database Home page, click the Server link to view the Server subpage.

  2. Under Database Configuration, click All Initialization Parameters.

    Oracle Enterprise Manager Database Control (Database Control) displays the Initialization Parameters page.

    Description of init_params.gif follows
    Description of the illustration init_params.gif

    The Initialization Parameters page has two subpages:

    • Current—This subpage (the default) displays all initialization parameter values that are currently active (in memory) for the Oracle instance.

    • SPFile—This subpage displays initialization parameter settings in the server parameter file. This subpage is present only when the current instance started up with a server parameter file. The file location is displayed at the top of the subpage.

    See the online Help for the Initialization Parameters page for field descriptions.

  3. (Optional) On either subpage, reduce the number of initialization parameters displayed by doing one or both of the following, and then clicking Go:

    • In the Name field, enter text.

    • Select from one or more of the lists next to the Name field.

    For example, to view only initialization parameters that have the text "dest" anywhere in the parameter name, enter dest in the Name field, and then click Go.

  4. To modify one or more initialization parameters for the currently running instance only, with the modifications being lost when the instance is restarted, complete the following steps:

    1. On the Current subpage, in the Value column, enter new values for the initialization parameters.

      Note:

      If the Value column cannot be written to for a particular initialization parameter, it means that this parameter is not dynamic—that is, it cannot be changed for the current instance.
    2. Ensure that Apply changes in current running instance(s) mode to SPFile is not selected.

    3. (Optional) In the Comments column, enter text explaining the reasons for the changes.

    4. Click Apply.

      A confirmation message appears.

  5. To modify initialization parameters for the currently running instance, and also record the modifications in the server parameter file that will persist when the database is restarted, complete the following steps:

    1. On the Current subpage, in the Value column, enter new values for the initialization parameters.

    2. Select Apply changes in current running instance(s) mode to SPFile.

    3. (Optional) In the Comments column, enter text explaining the reasons for the changes.

    4. Click Apply.

      A confirmation message appears.

  6. To modify initialization parameters in the server parameter file only, such that the current instance is not affected and changes take effect only when the database is next restarted, complete the following steps:

    1. Click the SPFile link to view the SPFile subpage.

    2. (Optional) Reduce the number of entries in the initialization parameter list as described in Step 3.

    3. In the Value column, enter new values for the initialization parameters.

    4. (Optional) In the Comments column, enter text explaining the reasons for the changes.

    5. Click Apply.

      A confirmation message appears.

Note:

Changes to initialization parameters are recorded in the alert log as ALTER SYSTEM statements. See Oracle Database Administrator's Guide for information about the alert log.