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.