SqlPlanBaselineConfiguration¶
- class oci.database_management.models.SqlPlanBaselineConfiguration(**kwargs)¶
Bases:
objectThe 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:
Gets the auto_capture_filters of this SqlPlanBaselineConfiguration.
Gets the auto_spm_evolve_task_parameters of this SqlPlanBaselineConfiguration.
[Required] Gets the is_auto_spm_evolve_task_enabled of this SqlPlanBaselineConfiguration.
[Required] Gets the is_automatic_initial_plan_capture_enabled of this SqlPlanBaselineConfiguration.
[Required] Gets the is_high_frequency_auto_spm_evolve_task_enabled of this SqlPlanBaselineConfiguration.
[Required] Gets the is_sql_plan_baselines_usage_enabled of this SqlPlanBaselineConfiguration.
[Required] Gets the plan_retention_weeks of this SqlPlanBaselineConfiguration.
Gets the space_budget_mb of this SqlPlanBaselineConfiguration.
[Required] Gets the space_budget_percent of this SqlPlanBaselineConfiguration.
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.
- property 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
- property 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
- property 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
- property 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
- property 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
- property 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
- property 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
- property 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
- property 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
- property 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