SpmEvolveTaskParameters¶
- class oci.database_management.models.SpmEvolveTaskParameters(**kwargs)¶
Bases:
objectThe set of parameters used in an SPM evolve task.
Attributes:
A constant which can be used with the alternate_plan_baselines property of a SpmEvolveTaskParameters.
A constant which can be used with the alternate_plan_baselines property of a SpmEvolveTaskParameters.
A constant which can be used with the alternate_plan_baselines property of a SpmEvolveTaskParameters.
A constant which can be used with the alternate_plan_sources property of a SpmEvolveTaskParameters.
A constant which can be used with the alternate_plan_sources property of a SpmEvolveTaskParameters.
A constant which can be used with the alternate_plan_sources property of a SpmEvolveTaskParameters.
A constant which can be used with the alternate_plan_sources property of a SpmEvolveTaskParameters.
Gets the allowed_time_limit of this SpmEvolveTaskParameters.
Gets the alternate_plan_baselines of this SpmEvolveTaskParameters.
Gets the alternate_plan_limit of this SpmEvolveTaskParameters.
Gets the alternate_plan_sources of this SpmEvolveTaskParameters.
Gets the are_plans_auto_accepted of this SpmEvolveTaskParameters.
Methods:
__init__(**kwargs)Initializes a new SpmEvolveTaskParameters object with values from keyword arguments.
- ALTERNATE_PLAN_BASELINES_AUTO = 'AUTO'¶
A constant which can be used with the alternate_plan_baselines property of a SpmEvolveTaskParameters. This constant has a value of “AUTO”
- ALTERNATE_PLAN_BASELINES_EXISTING = 'EXISTING'¶
A constant which can be used with the alternate_plan_baselines property of a SpmEvolveTaskParameters. This constant has a value of “EXISTING”
- ALTERNATE_PLAN_BASELINES_NEW = 'NEW'¶
A constant which can be used with the alternate_plan_baselines property of a SpmEvolveTaskParameters. This constant has a value of “NEW”
- ALTERNATE_PLAN_SOURCES_AUTO = 'AUTO'¶
A constant which can be used with the alternate_plan_sources property of a SpmEvolveTaskParameters. This constant has a value of “AUTO”
- ALTERNATE_PLAN_SOURCES_AUTOMATIC_WORKLOAD_REPOSITORY = 'AUTOMATIC_WORKLOAD_REPOSITORY'¶
A constant which can be used with the alternate_plan_sources property of a SpmEvolveTaskParameters. This constant has a value of “AUTOMATIC_WORKLOAD_REPOSITORY”
- ALTERNATE_PLAN_SOURCES_CURSOR_CACHE = 'CURSOR_CACHE'¶
A constant which can be used with the alternate_plan_sources property of a SpmEvolveTaskParameters. This constant has a value of “CURSOR_CACHE”
- ALTERNATE_PLAN_SOURCES_SQL_TUNING_SET = 'SQL_TUNING_SET'¶
A constant which can be used with the alternate_plan_sources property of a SpmEvolveTaskParameters. This constant has a value of “SQL_TUNING_SET”
- __init__(**kwargs)¶
Initializes a new SpmEvolveTaskParameters object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):
- Parameters
alternate_plan_sources (list[str]) – The value to assign to the alternate_plan_sources property of this SpmEvolveTaskParameters. Allowed values for items in this list are: “AUTO”, “AUTOMATIC_WORKLOAD_REPOSITORY”, “CURSOR_CACHE”, “SQL_TUNING_SET”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
alternate_plan_baselines (list[str]) – The value to assign to the alternate_plan_baselines property of this SpmEvolveTaskParameters. Allowed values for items in this list are: “AUTO”, “EXISTING”, “NEW”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
alternate_plan_limit (int) – The value to assign to the alternate_plan_limit property of this SpmEvolveTaskParameters.
are_plans_auto_accepted (bool) – The value to assign to the are_plans_auto_accepted property of this SpmEvolveTaskParameters.
allowed_time_limit (int) – The value to assign to the allowed_time_limit property of this SpmEvolveTaskParameters.
- property allowed_time_limit¶
Gets the allowed_time_limit of this SpmEvolveTaskParameters. The global time limit in seconds. This is the total time allowed for the task.
- Returns
The allowed_time_limit of this SpmEvolveTaskParameters.
- Return type
int
- property alternate_plan_baselines¶
Gets the alternate_plan_baselines of this SpmEvolveTaskParameters. Determines which alternative plans should be loaded.
Allowed values for items in this list are: “AUTO”, “EXISTING”, “NEW”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The alternate_plan_baselines of this SpmEvolveTaskParameters.
- Return type
list[str]
- property alternate_plan_limit¶
Gets the alternate_plan_limit of this SpmEvolveTaskParameters. Specifies the maximum number of plans to load in total (that is, not the limit for each SQL statement). A value of zero indicates UNLIMITED number of plans.
- Returns
The alternate_plan_limit of this SpmEvolveTaskParameters.
- Return type
int
- property alternate_plan_sources¶
Gets the alternate_plan_sources of this SpmEvolveTaskParameters. Determines which sources to search for additional plans.
Allowed values for items in this list are: “AUTO”, “AUTOMATIC_WORKLOAD_REPOSITORY”, “CURSOR_CACHE”, “SQL_TUNING_SET”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The alternate_plan_sources of this SpmEvolveTaskParameters.
- Return type
list[str]
- property are_plans_auto_accepted¶
Gets the are_plans_auto_accepted of this SpmEvolveTaskParameters. Specifies whether to accept recommended plans automatically.
- Returns
The are_plans_auto_accepted of this SpmEvolveTaskParameters.
- Return type
bool