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.

property credentials

Gets the credentials of this LoadSqlPlanBaselinesFromCursorCacheDetails.

Returns

The credentials of this LoadSqlPlanBaselinesFromCursorCacheDetails.

Return type

oci.database_management.models.ManagedDatabaseCredential

property database_credential

Gets the database_credential of this LoadSqlPlanBaselinesFromCursorCacheDetails.

Returns

The database_credential of this LoadSqlPlanBaselinesFromCursorCacheDetails.

Return type

oci.database_management.models.DatabaseCredentialDetails

property 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

property 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

property 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

property 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

property job_description

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

Returns

The job_description of this LoadSqlPlanBaselinesFromCursorCacheDetails.

Return type

str

property 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

property 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

property 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

property 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

property 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