ChangeSqlPlanBaselinesAttributesDetails¶
- class oci.database_management.models.ChangeSqlPlanBaselinesAttributesDetails(**kwargs)¶
Bases:
objectThe details required to change SQL plan baseline attributes. It takes either credentials or databaseCredential. It’s recommended to provide databaseCredential
Methods:
__init__(**kwargs)Initializes a new ChangeSqlPlanBaselinesAttributesDetails object with values from keyword arguments.
Attributes:
Gets the credentials of this ChangeSqlPlanBaselinesAttributesDetails.
Gets the database_credential of this ChangeSqlPlanBaselinesAttributesDetails.
Gets the is_auto_purged of this ChangeSqlPlanBaselinesAttributesDetails.
Gets the is_enabled of this ChangeSqlPlanBaselinesAttributesDetails.
Gets the is_fixed of this ChangeSqlPlanBaselinesAttributesDetails.
Gets the plan_name of this ChangeSqlPlanBaselinesAttributesDetails. Then plan name. It identifies a specific plan. If `null' then all plans associated with a SQL statement identified by `sqlHandle' are considered for attribute changes.
Gets the sql_handle of this ChangeSqlPlanBaselinesAttributesDetails.
- __init__(**kwargs)¶
Initializes a new ChangeSqlPlanBaselinesAttributesDetails object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):
- Parameters
sql_handle (str) – The value to assign to the sql_handle property of this ChangeSqlPlanBaselinesAttributesDetails.
plan_name (str) – The value to assign to the plan_name property of this ChangeSqlPlanBaselinesAttributesDetails.
is_enabled (bool) – The value to assign to the is_enabled property of this ChangeSqlPlanBaselinesAttributesDetails.
is_fixed (bool) – The value to assign to the is_fixed property of this ChangeSqlPlanBaselinesAttributesDetails.
is_auto_purged (bool) – The value to assign to the is_auto_purged property of this ChangeSqlPlanBaselinesAttributesDetails.
credentials (oci.database_management.models.ManagedDatabaseCredential) – The value to assign to the credentials property of this ChangeSqlPlanBaselinesAttributesDetails.
database_credential (oci.database_management.models.DatabaseCredentialDetails) – The value to assign to the database_credential property of this ChangeSqlPlanBaselinesAttributesDetails.
- property credentials¶
Gets the credentials of this ChangeSqlPlanBaselinesAttributesDetails.
- Returns
The credentials of this ChangeSqlPlanBaselinesAttributesDetails.
- Return type
- property database_credential¶
Gets the database_credential of this ChangeSqlPlanBaselinesAttributesDetails.
- Returns
The database_credential of this ChangeSqlPlanBaselinesAttributesDetails.
- Return type
- property is_auto_purged¶
Gets the is_auto_purged of this ChangeSqlPlanBaselinesAttributesDetails. Indicates whether the plan is purged if it is not used for a time period.
- Returns
The is_auto_purged of this ChangeSqlPlanBaselinesAttributesDetails.
- Return type
bool
- property is_enabled¶
Gets the is_enabled of this ChangeSqlPlanBaselinesAttributesDetails. Indicates whether the plan is available for use by the optimizer.
- Returns
The is_enabled of this ChangeSqlPlanBaselinesAttributesDetails.
- Return type
bool
- property is_fixed¶
Gets the is_fixed of this ChangeSqlPlanBaselinesAttributesDetails. Indicates whether the plan baseline is fixed. A fixed plan takes precedence over a non-fixed plan.
- Returns
The is_fixed of this ChangeSqlPlanBaselinesAttributesDetails.
- Return type
bool
- property plan_name¶
Gets the plan_name of this ChangeSqlPlanBaselinesAttributesDetails. Then plan name. It identifies a specific plan. If `null’ then all plans associated with a SQL statement identified by `sqlHandle’ are considered for attribute changes.
- Returns
The plan_name of this ChangeSqlPlanBaselinesAttributesDetails.
- Return type
str
- property sql_handle¶
Gets the sql_handle of this ChangeSqlPlanBaselinesAttributesDetails. The SQL statement handle. It identifies plans associated with a SQL statement for attribute changes. If null then planName must be specified.
- Returns
The sql_handle of this ChangeSqlPlanBaselinesAttributesDetails.
- Return type
str