LoadSqlPlanBaselinesFromCursorCacheDetails¶

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

Bases: object

The details of SQL statements and plans to be loaded from cursor cache. You can specify the plans to load using SQL ID, plan identifier, or filterName and filterValue pair. You can also control the SQL plan baseline into which the plans are loaded using either SQL text or SQL handle. It takes either credentials or databaseCredential. It’s recommended to provide databaseCredential

Attributes

`FILTER_NAME_ACTION`	A constant which can be used with the filter_name property of a LoadSqlPlanBaselinesFromCursorCacheDetails.
`FILTER_NAME_MODULE`	A constant which can be used with the filter_name property of a LoadSqlPlanBaselinesFromCursorCacheDetails.
`FILTER_NAME_PARSING_SCHEMA_NAME`	A constant which can be used with the filter_name property of a LoadSqlPlanBaselinesFromCursorCacheDetails.
`FILTER_NAME_SQL_TEXT`	A constant which can be used with the filter_name property of a LoadSqlPlanBaselinesFromCursorCacheDetails.
`credentials`	Gets the credentials of this LoadSqlPlanBaselinesFromCursorCacheDetails.
`database_credential`	Gets the database_credential of this LoadSqlPlanBaselinesFromCursorCacheDetails.
`filter_name`	Gets the filter_name of this LoadSqlPlanBaselinesFromCursorCacheDetails.
`filter_value`	Gets the filter_value of this LoadSqlPlanBaselinesFromCursorCacheDetails.
`is_enabled`	Gets the is_enabled of this LoadSqlPlanBaselinesFromCursorCacheDetails.
`is_fixed`	Gets the is_fixed of this LoadSqlPlanBaselinesFromCursorCacheDetails.
`job_description`	Gets the job_description of this LoadSqlPlanBaselinesFromCursorCacheDetails.
`job_name`	[Required] Gets the job_name of this LoadSqlPlanBaselinesFromCursorCacheDetails.
`plan_hash`	Gets the plan_hash of this LoadSqlPlanBaselinesFromCursorCacheDetails.
`sql_handle`	Gets the sql_handle of this LoadSqlPlanBaselinesFromCursorCacheDetails.
`sql_id`	Gets the sql_id of this LoadSqlPlanBaselinesFromCursorCacheDetails.
`sql_text`	Gets the sql_text of this LoadSqlPlanBaselinesFromCursorCacheDetails.

Methods

__init__(**kwargs) Initializes a new LoadSqlPlanBaselinesFromCursorCacheDetails object with values from keyword arguments.

FILTER_NAME_ACTION = 'ACTION'¶: A constant which can be used with the filter_name property of a LoadSqlPlanBaselinesFromCursorCacheDetails. This constant has a value of “ACTION”

FILTER_NAME_MODULE = 'MODULE'¶: A constant which can be used with the filter_name property of a LoadSqlPlanBaselinesFromCursorCacheDetails. This constant has a value of “MODULE”

FILTER_NAME_PARSING_SCHEMA_NAME = 'PARSING_SCHEMA_NAME'¶: A constant which can be used with the filter_name property of a LoadSqlPlanBaselinesFromCursorCacheDetails. This constant has a value of “PARSING_SCHEMA_NAME”

FILTER_NAME_SQL_TEXT = 'SQL_TEXT'¶: A constant which can be used with the filter_name property of a LoadSqlPlanBaselinesFromCursorCacheDetails. This constant has a value of “SQL_TEXT”

__init__(**kwargs)¶

Initializes a new LoadSqlPlanBaselinesFromCursorCacheDetails 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 LoadSqlPlanBaselinesFromCursorCacheDetails.
job_description (str) – The value to assign to the job_description property of this LoadSqlPlanBaselinesFromCursorCacheDetails.
sql_id (str) – The value to assign to the sql_id property of this LoadSqlPlanBaselinesFromCursorCacheDetails.
plan_hash (float) – The value to assign to the plan_hash property of this LoadSqlPlanBaselinesFromCursorCacheDetails.
sql_text (str) – The value to assign to the sql_text property of this LoadSqlPlanBaselinesFromCursorCacheDetails.
sql_handle (str) – The value to assign to the sql_handle property of this LoadSqlPlanBaselinesFromCursorCacheDetails.
filter_name (str) – The value to assign to the filter_name property of this LoadSqlPlanBaselinesFromCursorCacheDetails. Allowed values for this property are: “SQL_TEXT”, “PARSING_SCHEMA_NAME”, “MODULE”, “ACTION”
filter_value (str) – The value to assign to the filter_value property of this LoadSqlPlanBaselinesFromCursorCacheDetails.
is_fixed (bool) – The value to assign to the is_fixed property of this LoadSqlPlanBaselinesFromCursorCacheDetails.
is_enabled (bool) – The value to assign to the is_enabled property of this LoadSqlPlanBaselinesFromCursorCacheDetails.
credentials (oci.database_management.models.ManagedDatabaseCredential) – The value to assign to the credentials property of this LoadSqlPlanBaselinesFromCursorCacheDetails.
database_credential (oci.database_management.models.DatabaseCredentialDetails) – The value to assign to the database_credential property of this LoadSqlPlanBaselinesFromCursorCacheDetails.

credentials¶

Gets the credentials of this LoadSqlPlanBaselinesFromCursorCacheDetails.

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

database_credential¶

Gets the database_credential of this LoadSqlPlanBaselinesFromCursorCacheDetails.

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

filter_name¶

Gets the filter_name of this LoadSqlPlanBaselinesFromCursorCacheDetails. The name of the filter.

SQL_TEXT: Search pattern to apply to SQL text.
PARSING_SCHEMA_NAME: Name of the parsing schema.
MODULE: Name of the module.
ACTION: Name of the action.

Allowed values for this property are: “SQL_TEXT”, “PARSING_SCHEMA_NAME”, “MODULE”, “ACTION”

Returns:	The filter_name of this LoadSqlPlanBaselinesFromCursorCacheDetails.
Return type:	str

filter_value¶

Gets the filter_value of this LoadSqlPlanBaselinesFromCursorCacheDetails. The filter value. It is upper-cased except when it is enclosed in double quotes or filter name is SQL_TEXT.

Returns:	The filter_value of this LoadSqlPlanBaselinesFromCursorCacheDetails.
Return type:	str

is_enabled¶

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

Returns:	The is_enabled of this LoadSqlPlanBaselinesFromCursorCacheDetails.
Return type:	bool

is_fixed¶

Gets the is_fixed of this LoadSqlPlanBaselinesFromCursorCacheDetails. 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 LoadSqlPlanBaselinesFromCursorCacheDetails.
Return type:	bool

job_description¶

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

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

job_name¶

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

Returns:	The job_name of this LoadSqlPlanBaselinesFromCursorCacheDetails.
Return type:	str

plan_hash¶

Gets the plan_hash of this LoadSqlPlanBaselinesFromCursorCacheDetails. The plan identifier. By default, all plans present in the cursor cache for the SQL statement identified by sqlId are captured.

Returns:	The plan_hash of this LoadSqlPlanBaselinesFromCursorCacheDetails.
Return type:	float

sql_handle¶

Gets the sql_handle of this LoadSqlPlanBaselinesFromCursorCacheDetails. The SQL handle to use in identifying the SQL plan baseline into which the plans are loaded.

Returns:	The sql_handle of this LoadSqlPlanBaselinesFromCursorCacheDetails.
Return type:	str

sql_id¶

Gets the sql_id of this LoadSqlPlanBaselinesFromCursorCacheDetails. The SQL statement identifier. Identifies a SQL statement in the cursor cache.

Returns:	The sql_id of this LoadSqlPlanBaselinesFromCursorCacheDetails.
Return type:	str

sql_text¶

Gets the sql_text of this LoadSqlPlanBaselinesFromCursorCacheDetails. The SQL text to use in identifying the SQL plan baseline into which the plans are loaded. If the SQL plan baseline does not exist, it is created.

Returns:	The sql_text of this LoadSqlPlanBaselinesFromCursorCacheDetails.
Return type:	str