Database Reference
In-Depth Information
GENERAL INFORMATION SECTION
-------------------------------------------------
Task Information:
---------------------------------------------
Task Name : SYS_AUTO_SPM_EVOLVE_TASK
Task Owner : SYS
Description : Automatic SPM Evolve Task
Execution Name : EXEC_6294
Execution Type : SPM EVOLVE
Scope : COMPREHENSIVE
Status : COMPLETED
Started : 04/23/2014 22:00:19
Finished : 04/23/2014 22:00:19
Last Updated : 04/23/2014 22:00:19
Global Time Limit : 3600
Per-Plan Time Limit : UNUSED
Number of Errors : 0
-------------------------------------------------
SUMMARY SECTION
-------------------------------------------------
Number of plans processed : 0
Number of findings : 0
Number of recommendations : 0
Number of errors : 0
-------------------------------------------------
Altering SQL Plan Baselines
You can use the alter_sql_plan_baseline procedure in the dbms_spm package to modify some of the properties
specified when the SQL plan baseline was created. The sql_handle and plan_name parameters identify the SQL
plan baseline to be modified. At least one of the two must be specified. The attribute_name and attribute_value
parameters specify the property to be modified and its new value. The attribute_name parameter accepts the
following values:
enabled : This attribute can be set to either yes or no , although a SQL plan baseline can be
used by the query optimizer only when set to yes .
fixed : With this attribute set to yes , no new execution plan is added to a SQL plan baseline
and, as a result, it can't be evolved over time. In addition, if a SQL plan baseline contains
several accepted execution plans, a fixed execution plan is preferred over a nonfixed one.
It can be set to either yes or no .
autopurge : A SQL plan baseline with this attribute set to yes is automatically removed if it's
not used over a retention period (the configuration of the retention is discussed later in the
“Dropping SQL Plan Baselines” section). It can be set to either yes or no .
plan_name : This attribute is used to change the SQL plan name. It can be any string of up to
30 characters.
 
Search WWH ::




Custom Search