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.

begin_snapshot¶

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

Returns:	The begin_snapshot of this LoadSqlPlanBaselinesFromAwrDetails.
Return type:	int

credentials¶

Gets the credentials of this LoadSqlPlanBaselinesFromAwrDetails.

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

database_credential¶

Gets the database_credential of this LoadSqlPlanBaselinesFromAwrDetails.

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

end_snapshot¶

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

Returns:	The end_snapshot of this LoadSqlPlanBaselinesFromAwrDetails.
Return type:	int

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

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

job_description¶

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

Returns:	The job_description of this LoadSqlPlanBaselinesFromAwrDetails.
Return type:	str

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

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