OPTIMIZER_USE_SQL_PLAN_BASELINES：OPTIMIZER_USE_SQL_PLAN_BASELINES enables or disables the use of SQL plan baselines stored in SQL Management Base. When enabled, the optimizer looks for a SQL plan baseline for the SQL statement being compiled. If one is found in SQL Management Base, then the optimizer will cost each of the baseline plans and pick one with the lowest cost. Parameter type: Boolean Default value: true Modifiable: ALTER SESSION, ALTER SYSTEM Range of values: true | false Basic: No ORACLE_TRACE_COLLECTION_NAME Specifies the Oracle Trace collection name. This parameter is also used in the output file names (collection definition file .CDF and data file .DAT). This parameter is obsolete in 10.1. Default Value: NULL
错误码
错误描述：OPTIMIZER_USE_SQL_PLAN_BASELINES enables or disables the use of SQL plan baselines stored in SQL Management Base. When enabled, the optimizer looks for a SQL plan baseline for the SQL statement being compiled. If one is found in SQL Management Base, then the optimizer will cost each of the baseline plans and pick one with the lowest cost.
Parameter type: Boolean
Default value: true
Modifiable: ALTER SESSION, ALTER SYSTEM
Range of values: true | false
Basic: No
ORACLE_TRACE_COLLECTION_NAME
Specifies the Oracle Trace collection name. This parameter is also used in the output file names (collection definition file .CDF and data file .DAT). This parameter is obsolete in 10.1.
Default Value: NULL
向认证技术专家提问
向技术专家提问
