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. 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.

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.

property credentials

Gets the credentials of this ChangeSqlPlanBaselinesAttributesDetails.

Returns

The credentials of this ChangeSqlPlanBaselinesAttributesDetails.

Return type

oci.database_management.models.ManagedDatabaseCredential

property database_credential

Gets the database_credential of this ChangeSqlPlanBaselinesAttributesDetails.

Returns

The database_credential of this ChangeSqlPlanBaselinesAttributesDetails.

Return type

oci.database_management.models.DatabaseCredentialDetails

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