LoadSqlPlanBaselinesFromAwrDetails

class oci.database_management.models.LoadSqlPlanBaselinesFromAwrDetails(**kwargs)

Bases: object

The details required to load plans from Automatic Workload Repository (AWR). It takes either credentials or databaseCredential. It’s recommended to provide databaseCredential

Methods:

__init__(**kwargs)

Initializes a new LoadSqlPlanBaselinesFromAwrDetails object with values from keyword arguments.

Attributes:

begin_snapshot

[Required] Gets the begin_snapshot of this LoadSqlPlanBaselinesFromAwrDetails.

credentials

Gets the credentials of this LoadSqlPlanBaselinesFromAwrDetails.

database_credential

Gets the database_credential of this LoadSqlPlanBaselinesFromAwrDetails.

end_snapshot

[Required] Gets the end_snapshot of this LoadSqlPlanBaselinesFromAwrDetails.

is_enabled

Gets the is_enabled of this LoadSqlPlanBaselinesFromAwrDetails.

is_fixed

Gets the is_fixed of this LoadSqlPlanBaselinesFromAwrDetails.

job_description

Gets the job_description of this LoadSqlPlanBaselinesFromAwrDetails.

job_name

[Required] Gets the job_name of this LoadSqlPlanBaselinesFromAwrDetails.

sql_text_filter

Gets the sql_text_filter of this LoadSqlPlanBaselinesFromAwrDetails.

__init__(**kwargs)

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

Parameters
  • job_name (str) – The value to assign to the job_name property of this LoadSqlPlanBaselinesFromAwrDetails.

  • job_description (str) – The value to assign to the job_description property of this LoadSqlPlanBaselinesFromAwrDetails.

  • begin_snapshot (int) – The value to assign to the begin_snapshot property of this LoadSqlPlanBaselinesFromAwrDetails.

  • end_snapshot (int) – The value to assign to the end_snapshot property of this LoadSqlPlanBaselinesFromAwrDetails.

  • sql_text_filter (str) – The value to assign to the sql_text_filter property of this LoadSqlPlanBaselinesFromAwrDetails.

  • is_fixed (bool) – The value to assign to the is_fixed property of this LoadSqlPlanBaselinesFromAwrDetails.

  • is_enabled (bool) – The value to assign to the is_enabled property of this LoadSqlPlanBaselinesFromAwrDetails.

  • credentials (oci.database_management.models.ManagedDatabaseCredential) – The value to assign to the credentials property of this LoadSqlPlanBaselinesFromAwrDetails.

  • database_credential (oci.database_management.models.DatabaseCredentialDetails) – The value to assign to the database_credential property of this LoadSqlPlanBaselinesFromAwrDetails.

property begin_snapshot

[Required] Gets the begin_snapshot of this LoadSqlPlanBaselinesFromAwrDetails. The begin snapshot.

Returns

The begin_snapshot of this LoadSqlPlanBaselinesFromAwrDetails.

Return type

int

property credentials

Gets the credentials of this LoadSqlPlanBaselinesFromAwrDetails.

Returns

The credentials of this LoadSqlPlanBaselinesFromAwrDetails.

Return type

oci.database_management.models.ManagedDatabaseCredential

property database_credential

Gets the database_credential of this LoadSqlPlanBaselinesFromAwrDetails.

Returns

The database_credential of this LoadSqlPlanBaselinesFromAwrDetails.

Return type

oci.database_management.models.DatabaseCredentialDetails

property end_snapshot

[Required] Gets the end_snapshot of this LoadSqlPlanBaselinesFromAwrDetails. The end snapshot.

Returns

The end_snapshot of this LoadSqlPlanBaselinesFromAwrDetails.

Return type

int

property is_enabled

Gets the is_enabled of this LoadSqlPlanBaselinesFromAwrDetails. Indicates whether the loaded plans are enabled (true) or not (false). By default, they are enabled.

Returns

The is_enabled of this LoadSqlPlanBaselinesFromAwrDetails.

Return type

bool

property is_fixed

Gets the is_fixed of this LoadSqlPlanBaselinesFromAwrDetails. Indicates whether the plans are loaded as fixed plans (true) or non-fixed plans (false). By default, they are loaded as non-fixed plans.

Returns

The is_fixed of this LoadSqlPlanBaselinesFromAwrDetails.

Return type

bool

property job_description

Gets the job_description of this LoadSqlPlanBaselinesFromAwrDetails. The description of the job.

Returns

The job_description of this LoadSqlPlanBaselinesFromAwrDetails.

Return type

str

property job_name

[Required] Gets the job_name of this LoadSqlPlanBaselinesFromAwrDetails. The name of the database job used for loading SQL plan baselines.

Returns

The job_name of this LoadSqlPlanBaselinesFromAwrDetails.

Return type

str

property sql_text_filter

Gets the sql_text_filter of this LoadSqlPlanBaselinesFromAwrDetails. A filter applied to AWR to select only qualifying plans to be loaded. By default all plans in AWR are selected. The filter can take the form of any WHERE clause predicate that can be specified against the column DBA_HIST_SQLTEXT.SQL_TEXT. An example is sql_text like ‘SELECT %’.

Returns

The sql_text_filter of this LoadSqlPlanBaselinesFromAwrDetails.

Return type

str