Setting Configuration Options

Configuration options set database performance and tuning parameters. Configuration options should be used when network infrastructure requires tuning of the database engine I/O activity.

  To configure configuration options:

  1. Open the Configuration Options dialog box:

    • From Workbench: Select Tools > Configuration Settings.

    • From the Web client: Select Administration > Configuration Options.

  2. From Options, select a configuration option.

    Details of each of the thirty-one configuration options are listed in the following topics:

    • General Options

    • SQL Tuning Configuration Options

    • Oracle Tuning Configuration Options

    • Other General Configuration Options

  3. Select the option settings.

    The option settings are located on the bottom half of the Configuration Options dialog box. The configuration option that is selected in Options determines which option settings are displayed.