ChangeSqlPlanBaselinesAttributesDetails¶

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

Bases: object

The 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

`credentials`	Gets the credentials of this ChangeSqlPlanBaselinesAttributesDetails.
`database_credential`	Gets the database_credential of this ChangeSqlPlanBaselinesAttributesDetails.
`is_auto_purged`	Gets the is_auto_purged of this ChangeSqlPlanBaselinesAttributesDetails.
`is_enabled`	Gets the is_enabled of this ChangeSqlPlanBaselinesAttributesDetails.
`is_fixed`	Gets the is_fixed of this ChangeSqlPlanBaselinesAttributesDetails.
`plan_name`	Gets the plan_name of this ChangeSqlPlanBaselinesAttributesDetails.
`sql_handle`	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.

credentials¶

Gets the credentials of this ChangeSqlPlanBaselinesAttributesDetails.

Returns:	The credentials of this ChangeSqlPlanBaselinesAttributesDetails.
Return type:	oci.database_management.models.ManagedDatabaseCredential

database_credential¶

Gets the database_credential of this ChangeSqlPlanBaselinesAttributesDetails.

Returns:	The database_credential of this ChangeSqlPlanBaselinesAttributesDetails.
Return type:	oci.database_management.models.DatabaseCredentialDetails

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

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

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

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

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