The <oracle-settings> database configuration element

The <database> element in file database-config.xml contains, at most, a single occurrence of subelement <oracle-settings>. The use of the <oracle-settings> element is optional. Use this element to configure Oracle-only database parameters.

The <oracle-settings> element has the following syntax.

<database>

   <oracle-settings adaptive-optimization="true|false" db-resource-mgr-cancel-sql="string"
        query-rewrite="true|false" statistics-level-all="true|false" 
        stored-outline-category="string"/>
  
</database>

The following list describes the attributes that you can configure on the <oracle-settings> element. All of these attributes are optional.

adaptive-optimization

Specifies the behavior of the Oracle Adaptive Optimization feature. Valid values are:

  • true - Does nothing; default if not set
  • false - Sets the parameter OPTIMIZER_ADAPTIVE_PLANS to false at the session level

db-resource-mgr-cancel-sql

Name of an Oracle Resource Consumer Group, if any.

query-rewrite

Boolean. Whether to enable query rewrite.

Valid values are:

  • true – Enable query rewrite and use a matching materialized view.
  • false – Set the Oracle query-rewrite parameter to false to disable use of Oracle materialized views.

If not present, Guidewire does not set this value at the session level

statistics-level-all

Boolean. Whether to set the Oracle statistics_level parameter to ALL and enable collection of detailed execution plan statistics.

The default is false.

stored-outline-category

Name of the stored outline category to use, if any

The <oracle-settings> element does not contain additional subelements.

See also