Configuring Cost Based Optimization Settings in the Database Instance Settings

Previous TopicNext TopicContents

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 P6 Administrator application.
  2. In the Configurations tab, expand your configuration.
  3. Expand Database/Instance[n]/Cost Based Optimization settings.
    1. In the Enable field, choose true to enable Cost Based Optimization. Choose false to disable it.
    2. In the Dump Matching SQL field, choose true to dump the SQL where a match is found in the QUERYLIB table for a given SQL statement.

      Choose false 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 Database Settings

Configuring Microsoft SharePoint in the Database Instance Settings

Configuring CMIS-Compliant Content Repository in the Database Instance Settings

Configuring the Oracle Database Content Repository

Configuring Session Settings in the Database Instance Settings

Configuring Eventing in the Database Instance Settings

Configuring AIA in the Database Instance Settings

Configuring Fusion Projects Settings in the Database Instance Settings

Configuring BI Publisher in the P6 Administrator application

Configuring P6 to Connect to Oracle BPM 11g



Legal Notices
Copyright © 1999, 2015, Oracle and/or its affiliates. All rights reserved.

Last Published Wednesday, July 29, 2015

PDF Library