SqlPlanBaselineConfiguration¶

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

Bases: object

The configuration details of SQL plan baselines. The details include:

whether automatic initial plan capture is enabled or disabled
whether use of SQL plan baselines is enabled or disabled
whether Automatic SPM Evolve Advisor task is enabled or disabled
whether high-frequency Automatic SPM Evolve Advisor task is enabled or disabled
filters for the automatic initial plan capture
parameters for the Automatic SPM Evolve Advisor task
plan retention and allocated space for the plan baselines

Methods

__init__(**kwargs) Initializes a new SqlPlanBaselineConfiguration object with values from keyword arguments.

Attributes

`auto_capture_filters`	Gets the auto_capture_filters of this SqlPlanBaselineConfiguration.
`auto_spm_evolve_task_parameters`	Gets the auto_spm_evolve_task_parameters of this SqlPlanBaselineConfiguration.
`is_auto_spm_evolve_task_enabled`	[Required] Gets the is_auto_spm_evolve_task_enabled of this SqlPlanBaselineConfiguration.
`is_automatic_initial_plan_capture_enabled`	[Required] Gets the is_automatic_initial_plan_capture_enabled of this SqlPlanBaselineConfiguration.
`is_high_frequency_auto_spm_evolve_task_enabled`	[Required] Gets the is_high_frequency_auto_spm_evolve_task_enabled of this SqlPlanBaselineConfiguration.
`is_sql_plan_baselines_usage_enabled`	[Required] Gets the is_sql_plan_baselines_usage_enabled of this SqlPlanBaselineConfiguration.
`plan_retention_weeks`	[Required] Gets the plan_retention_weeks of this SqlPlanBaselineConfiguration.
`space_budget_mb`	Gets the space_budget_mb of this SqlPlanBaselineConfiguration.
`space_budget_percent`	[Required] Gets the space_budget_percent of this SqlPlanBaselineConfiguration.
`space_used_mb`	Gets the space_used_mb of this SqlPlanBaselineConfiguration.

__init__(**kwargs)¶

Initializes a new SqlPlanBaselineConfiguration object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:

is_automatic_initial_plan_capture_enabled (bool) – The value to assign to the is_automatic_initial_plan_capture_enabled property of this SqlPlanBaselineConfiguration.
is_sql_plan_baselines_usage_enabled (bool) – The value to assign to the is_sql_plan_baselines_usage_enabled property of this SqlPlanBaselineConfiguration.
is_auto_spm_evolve_task_enabled (bool) – The value to assign to the is_auto_spm_evolve_task_enabled property of this SqlPlanBaselineConfiguration.
is_high_frequency_auto_spm_evolve_task_enabled (bool) – The value to assign to the is_high_frequency_auto_spm_evolve_task_enabled property of this SqlPlanBaselineConfiguration.
plan_retention_weeks (int) – The value to assign to the plan_retention_weeks property of this SqlPlanBaselineConfiguration.
space_budget_percent (float) – The value to assign to the space_budget_percent property of this SqlPlanBaselineConfiguration.
space_budget_mb (float) – The value to assign to the space_budget_mb property of this SqlPlanBaselineConfiguration.
space_used_mb (float) – The value to assign to the space_used_mb property of this SqlPlanBaselineConfiguration.
auto_capture_filters (list[oci.database_management.models.AutomaticCaptureFilter]) – The value to assign to the auto_capture_filters property of this SqlPlanBaselineConfiguration.
auto_spm_evolve_task_parameters (oci.database_management.models.SpmEvolveTaskParameters) – The value to assign to the auto_spm_evolve_task_parameters property of this SqlPlanBaselineConfiguration.

auto_capture_filters¶

Gets the auto_capture_filters of this SqlPlanBaselineConfiguration. The capture filters used in automatic initial plan capture.

Returns:	The auto_capture_filters of this SqlPlanBaselineConfiguration.
Return type:	list[oci.database_management.models.AutomaticCaptureFilter]

auto_spm_evolve_task_parameters¶

Gets the auto_spm_evolve_task_parameters of this SqlPlanBaselineConfiguration.

Returns:	The auto_spm_evolve_task_parameters of this SqlPlanBaselineConfiguration.
Return type:	oci.database_management.models.SpmEvolveTaskParameters

is_auto_spm_evolve_task_enabled¶

[Required] Gets the is_auto_spm_evolve_task_enabled of this SqlPlanBaselineConfiguration. Indicates whether the Automatic SPM Evolve Advisor task is enabled (true) or not (false).

Returns:	The is_auto_spm_evolve_task_enabled of this SqlPlanBaselineConfiguration.
Return type:	bool

is_automatic_initial_plan_capture_enabled¶

[Required] Gets the is_automatic_initial_plan_capture_enabled of this SqlPlanBaselineConfiguration. Indicates whether the automatic capture of SQL plan baselines is enabled (true) or not (false).

Returns:	The is_automatic_initial_plan_capture_enabled of this SqlPlanBaselineConfiguration.
Return type:	bool

is_high_frequency_auto_spm_evolve_task_enabled¶

[Required] Gets the is_high_frequency_auto_spm_evolve_task_enabled of this SqlPlanBaselineConfiguration. Indicates whether the high frequency Automatic SPM Evolve Advisor task is enabled (true) or not (false).

Returns:	The is_high_frequency_auto_spm_evolve_task_enabled of this SqlPlanBaselineConfiguration.
Return type:	bool

is_sql_plan_baselines_usage_enabled¶

[Required] Gets the is_sql_plan_baselines_usage_enabled of this SqlPlanBaselineConfiguration. Indicates whether the database uses SQL plan baselines (true) or not (false).

Returns:	The is_sql_plan_baselines_usage_enabled of this SqlPlanBaselineConfiguration.
Return type:	bool

plan_retention_weeks¶

[Required] Gets the plan_retention_weeks of this SqlPlanBaselineConfiguration. The number of weeks to retain unused plans before they are purged.

Returns:	The plan_retention_weeks of this SqlPlanBaselineConfiguration.
Return type:	int

space_budget_mb¶

Gets the space_budget_mb of this SqlPlanBaselineConfiguration. The maximum SYSAUX space that can be used for SQL Management Base in MB.

Returns:	The space_budget_mb of this SqlPlanBaselineConfiguration.
Return type:	float

space_budget_percent¶

[Required] Gets the space_budget_percent of this SqlPlanBaselineConfiguration. The maximum percent of SYSAUX space that can be used for SQL Management Base.

Returns:	The space_budget_percent of this SqlPlanBaselineConfiguration.
Return type:	float

space_used_mb¶

Gets the space_used_mb of this SqlPlanBaselineConfiguration. The space used by SQL Management Base in MB.

Returns:	The space_used_mb of this SqlPlanBaselineConfiguration.
Return type:	float