1. Using Oracle Database Management for Autonomous Databases
  2. View and Edit Autonomous Database Initialization Parameters

6 View and Edit Autonomous Database Initialization Parameters

Initialization parameters are configuration parameters that impact the basic operation of a database.

Autonomous Databases configure the database initialization parameters based on the compute and storage capacity you provision. You don't have to set any initialization parameters, however, you can edit a limited set of parameters if you need to on the Initialization Parameters page.

To go to the Initialization Parameters page, go to the Database Home page of an Autonomous Database entity and click Initialization Parameters in the Oracle Database navigation menu. The editable initialization parameters of your Autonomous Database entity are displayed in a table format with the following columns:

  • Name of the initialization parameter.
  • Value of the initialization parameter such as TRUE and FALSE.
  • Comment added for the initialization parameter.
  • Dynamic has a green check mark that denotes a dynamic parameter. The parameters without a green check mark are static parameters.
  • Type denotes the data type of the parameter value, such as Boolean or String.
  • Description of the initialization parameter.

For information on the initialization parameters that are displayed on the Initialization Parameters page, see Restrictions for Database Initialization Parameters in Using Oracle Autonomous Database on Shared Exadata Infrastructure.

Edit Initialization Parameters

You can edit the Value and Comment fields of an initialization parameter on the Initialization Parameters page.

  1. Go to the Initialization Parameters page.
  2. Click Edit on the top-right of the page.

    Editable fields are displayed in the Value and Comment columns.

  3. Add or edit the value and comment, and click Save.
  4. Click OK in the Save dialog box.

If the initialization parameter you've edited is a dynamic parameter, then the changes take effect immediately and a restart of the Autonomous Database is not required. However, if you edit a static parameter, then a restart of the Autonomous Database is required for the edits to take effect. Note that to restart your Autonomous Database, you'll have to go to the Oracle Cloud Infrastructure Console and stop and start your Autonomous Database. See To stop or start an Autonomous Database in Oracle Cloud Infrastructure documentation.