Viewing and Modifying Initialization Parameters

Initialization parameters configure the database instance, including memory structures, and define locations for database files.

Values for initialization parameters are stored in a text-based initialization parameter file (PFILE) or binary server parameter file (SPFILE). The initialization parameter file is read at database instance startup. For more information, see "Initialization Parameters" in Oracle Database Reference for Release 18, 12.2, 12.1 or 11.2.

To view and modify the value of an initialization parameter:

  1. From any DBaaS Monitor page, click Parameters from the Database drop-down menu.
  2. On the Parameters page, use the arrow buttons in the lower right corner to navigate the multiple pages of parameters, or use the search fields at the top of the page.
  3. To perform a search, enter values in the search criteria columns and click the search icon to locate the initialization parameter.
  4. Enter the new value in the Value field.
  5. Expand the Save changes menu and select the appropriate value:
    • To Memory: Updates the value for the existing database instance, but does not save it to the SPFILE.

    • To SPFILE: Updates the value in the SPFILE, but does not change it in the existing instance. The new value will take effect when the instance is restarted.

    • To both: Updates the values for the existing database instance and updates the value in the SPFILE.

  6. Click Yes to confirm your change.
  7. Click OK to close the Results page.