Setting Database Options

Adjust the configurable settings of a database to change the way the database behaves or performs.

Prerequisites
DBA authority is required.
Task
  1. In the Perspective Resources view, select a resource.
  2. From the application menu bar, select View > Open > Administration Console.
  3. In the left pane of the Administration Console, select Schema Objects > Databases.
  4. Select the database from the right pane and either:
    • Click the arrow to the right of the name and select Options, or,
    • From the Administration Console menu bar, select Resource > Options.
  5. In the Setting column, change a database option value and click Apply.
Related tasks
Viewing Database Properties
Creating a Database