SpmEvolveTaskParameters¶

class oci.database_management.models.SpmEvolveTaskParameters(**kwargs)¶

Bases: object

The set of parameters used in an SPM evolve task.

Attributes

`ALTERNATE_PLAN_BASELINES_AUTO`	A constant which can be used with the alternate_plan_baselines property of a SpmEvolveTaskParameters.
`ALTERNATE_PLAN_BASELINES_EXISTING`	A constant which can be used with the alternate_plan_baselines property of a SpmEvolveTaskParameters.
`ALTERNATE_PLAN_BASELINES_NEW`	A constant which can be used with the alternate_plan_baselines property of a SpmEvolveTaskParameters.
`ALTERNATE_PLAN_SOURCES_AUTO`	A constant which can be used with the alternate_plan_sources property of a SpmEvolveTaskParameters.
`ALTERNATE_PLAN_SOURCES_AUTOMATIC_WORKLOAD_REPOSITORY`	A constant which can be used with the alternate_plan_sources property of a SpmEvolveTaskParameters.
`ALTERNATE_PLAN_SOURCES_CURSOR_CACHE`	A constant which can be used with the alternate_plan_sources property of a SpmEvolveTaskParameters.
`ALTERNATE_PLAN_SOURCES_SQL_TUNING_SET`	A constant which can be used with the alternate_plan_sources property of a SpmEvolveTaskParameters.
`allowed_time_limit`	Gets the allowed_time_limit of this SpmEvolveTaskParameters.
`alternate_plan_baselines`	Gets the alternate_plan_baselines of this SpmEvolveTaskParameters.
`alternate_plan_limit`	Gets the alternate_plan_limit of this SpmEvolveTaskParameters.
`alternate_plan_sources`	Gets the alternate_plan_sources of this SpmEvolveTaskParameters.
`are_plans_auto_accepted`	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.

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

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]

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

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]

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