Configuring Cost Based Optimization Settings in the Database Instance Settings

The cost based optimization settings will enable you to manipulate base SQL queries based on optimization statistics.

Caution: Do not alter these settings unless you are familiar with cost based optimization. Contact My Oracle Support for more information.

To set your cost based optimization settings:

  1. Open the Primavera P6 Administrator.
  2. In the Configurations drop-down list, select your configuration.
  3. In the sidebar select Database/Instance[n]/Cost Based Optimization settings.

    Note: Changes to these settings require you to restart the P6 server.

    1. Select Enable, to enable Cost Based Optimization. Leave the field clear to disable it.
    2. Select Dump Matching SQL, select to dump the SQL where a match is found in the QUERYLIB table for a given SQL statement.

      Leaving the field clear to dump the SQL where a match is not found in the QUERYLIB table for a given SQL statement.

      Note: To see these entries, you must set your logging level to INFO in Configuring Log Settings.

Related Topics

About Database Instance Settings

Configuring Driver Class and URL for Database Instance Settings

Configuring User Security for Database Instance Settings

Configuring Connection Pool for Database Instance Settings

Configuring Oracle WebCenter Content Core Capabilities (WCCC) in the Database Instance Settings

Configuring the Oracle Database Content Repository

Configuring CMIS-Compliant Content Repository in the Database Instance Settings

Configuring Session Settings in the Database Instance Settings

Configuring Oracle Analytics Publisher in the Primavera P6 Administrator

Configuring P6 to Connect to Oracle BPM

Configuring Import/Export Options (Scheduled Service)


Last Published Monday, July 14, 2025