Guidelines for Optimizing Oracle Parallel Queries for Siebel Web Tools

Several queries performed by Siebel Web Tools or Siebel Tools can benefit from the parallel query feature for Oracle Database. Parallel hints have been added to the SELECT statements for such queries for Siebel Web Tools and Siebel Tools. The Siebel component parameter Oracle Degree of Parallelism (alias OraDegreeOfParallelism) allows setting the degree of parallelism for Siebel Web Tools or Siebel Tools, where parallel hints are present in the SELECT statements.

By default, the setting of OraDegreeOfParallelism is auto, which requires parallel settings in the Oracle Database, and might affect development work in other areas.

To optimize parallel queries, it is recommended to set OraDegreeOfParallelism for the Siebel Web Tools component to a value of 4. To do so, enter a command like the following in Server Manager:

change param OraDegreeOfParallelism=4 for comp SWToolsObjMgr_enu

To set this parameter for Siebel Tools, add OraDegreeOfParallelism under the [Siebel] section in tools.cfg, and set it to 4.

Note: The parameter Oracle Optimizer Ignore Hints (alias OraOptimizerIgnoreHints) is related. For parallel queries, do not change the default value, False, to True. If OraOptimizerIgnoreHints is set to True, then OraDegreeOfParallelism has no effect.

For more information using Server Manager and about setting component parameters, see Siebel System Administration Guide.

This topic is part of Configuring an Oracle Database for Siebel CRM.