LoadSqlTuningSetDetails

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

Bases: object

The details required to load the Sql statements into the Sql tuning set. It takes either credentialDetails or databaseCredential. It’s recommended to provide databaseCredential

Attributes:

CAPTURE_MODE_MODE_ACCUMULATE_STATS

A constant which can be used with the capture_mode property of a LoadSqlTuningSetDetails.

CAPTURE_MODE_MODE_REPLACE_OLD_STATS

A constant which can be used with the capture_mode property of a LoadSqlTuningSetDetails.

CAPTURE_OPTION_INSERT

A constant which can be used with the capture_option property of a LoadSqlTuningSetDetails.

CAPTURE_OPTION_MERGE

A constant which can be used with the capture_option property of a LoadSqlTuningSetDetails.

CAPTURE_OPTION_UPDATE

A constant which can be used with the capture_option property of a LoadSqlTuningSetDetails.

LOAD_OPTION_INSERT

A constant which can be used with the load_option property of a LoadSqlTuningSetDetails.

LOAD_OPTION_MERGE

A constant which can be used with the load_option property of a LoadSqlTuningSetDetails.

LOAD_OPTION_UPDATE

A constant which can be used with the load_option property of a LoadSqlTuningSetDetails.

LOAD_TYPE_AWR

A constant which can be used with the load_type property of a LoadSqlTuningSetDetails.

LOAD_TYPE_CURRENT_CURSOR_CACHE

A constant which can be used with the load_type property of a LoadSqlTuningSetDetails.

LOAD_TYPE_INCREMENTAL_CURSOR_CACHE

A constant which can be used with the load_type property of a LoadSqlTuningSetDetails.

RANKING_MEASURE1_BUFFER_GETS

A constant which can be used with the ranking_measure1 property of a LoadSqlTuningSetDetails.

RANKING_MEASURE1_CPU_TIME

A constant which can be used with the ranking_measure1 property of a LoadSqlTuningSetDetails.

RANKING_MEASURE1_DIRECT_WRITES

A constant which can be used with the ranking_measure1 property of a LoadSqlTuningSetDetails.

RANKING_MEASURE1_DISK_READS

A constant which can be used with the ranking_measure1 property of a LoadSqlTuningSetDetails.

RANKING_MEASURE1_ELAPSED_TIME

A constant which can be used with the ranking_measure1 property of a LoadSqlTuningSetDetails.

RANKING_MEASURE1_OPTIMIZER_COST

A constant which can be used with the ranking_measure1 property of a LoadSqlTuningSetDetails.

RANKING_MEASURE2_BUFFER_GETS

A constant which can be used with the ranking_measure2 property of a LoadSqlTuningSetDetails.

RANKING_MEASURE2_CPU_TIME

A constant which can be used with the ranking_measure2 property of a LoadSqlTuningSetDetails.

RANKING_MEASURE2_DIRECT_WRITES

A constant which can be used with the ranking_measure2 property of a LoadSqlTuningSetDetails.

RANKING_MEASURE2_DISK_READS

A constant which can be used with the ranking_measure2 property of a LoadSqlTuningSetDetails.

RANKING_MEASURE2_ELAPSED_TIME

A constant which can be used with the ranking_measure2 property of a LoadSqlTuningSetDetails.

RANKING_MEASURE2_OPTIMIZER_COST

A constant which can be used with the ranking_measure2 property of a LoadSqlTuningSetDetails.

RANKING_MEASURE3_BUFFER_GETS

A constant which can be used with the ranking_measure3 property of a LoadSqlTuningSetDetails.

RANKING_MEASURE3_CPU_TIME

A constant which can be used with the ranking_measure3 property of a LoadSqlTuningSetDetails.

RANKING_MEASURE3_DIRECT_WRITES

A constant which can be used with the ranking_measure3 property of a LoadSqlTuningSetDetails.

RANKING_MEASURE3_DISK_READS

A constant which can be used with the ranking_measure3 property of a LoadSqlTuningSetDetails.

RANKING_MEASURE3_ELAPSED_TIME

A constant which can be used with the ranking_measure3 property of a LoadSqlTuningSetDetails.

RANKING_MEASURE3_OPTIMIZER_COST

A constant which can be used with the ranking_measure3 property of a LoadSqlTuningSetDetails.

RECURSIVE_SQL_HAS_RECURSIVE_SQL

A constant which can be used with the recursive_sql property of a LoadSqlTuningSetDetails.

RECURSIVE_SQL_NO_RECURSIVE_SQL

A constant which can be used with the recursive_sql property of a LoadSqlTuningSetDetails.

UPDATE_CONDITION_NEW

A constant which can be used with the update_condition property of a LoadSqlTuningSetDetails.

UPDATE_CONDITION_NULL

A constant which can be used with the update_condition property of a LoadSqlTuningSetDetails.

UPDATE_CONDITION_OLD

A constant which can be used with the update_condition property of a LoadSqlTuningSetDetails.

UPDATE_OPTION_ACCUMULATE

A constant which can be used with the update_option property of a LoadSqlTuningSetDetails.

UPDATE_OPTION_REPLACE

A constant which can be used with the update_option property of a LoadSqlTuningSetDetails.

attribute_list

Gets the attribute_list of this LoadSqlTuningSetDetails. Specifies the list of Sql statement attributes to return in the result. Note that this parameter cannot be made an enum since custom value can take a list of comma separated attribute names. Attribute list can take one of the following values. TYPICAL - Specifies BASIC plus Sql plan (without row source statistics) and without object reference list (default). BASIC - Specifies all attributes (such as execution statistics and binds) except the plans. The execution context is always part of the result. ALL - Specifies all attributes. CUSTOM - Comma-separated list of the following attribute names. - EXECUTION_STATISTICS - BIND_LIST - OBJECT_LIST - SQL_PLAN - SQL_PLAN_STATISTICS Usage examples: 1. "attributeList": "TYPICAL" 2. "attributeList": "ALL" 3. "attributeList": "EXECUTION_STATISTICS,OBJECT_LIST,SQL_PLAN".

baseline_name

Gets the baseline_name of this LoadSqlTuningSetDetails.

basic_filter

Gets the basic_filter of this LoadSqlTuningSetDetails.

begin_snapshot

Gets the begin_snapshot of this LoadSqlTuningSetDetails.

capture_mode

Gets the capture_mode of this LoadSqlTuningSetDetails. Specifies the capture mode. Note that this parameter is applicable only for UPDATE and MERGE capture options. Capture mode can take one of the following values - MODE_REPLACE_OLD_STATS Replaces statistics when the number of executions is greater than the number stored in the Sql tuning set - MODE_ACCUMULATE_STATS Adds new values to current values for Sql that is already stored. Note that this mode detects if a statement has been aged out, so the final value for a statistics is the sum of the statistics of all cursors that statement existed under.

capture_option

Gets the capture_option of this LoadSqlTuningSetDetails.

commit_rows

Gets the commit_rows of this LoadSqlTuningSetDetails.

credential_details

Gets the credential_details of this LoadSqlTuningSetDetails.

database_credential

Gets the database_credential of this LoadSqlTuningSetDetails.

end_snapshot

Gets the end_snapshot of this LoadSqlTuningSetDetails.

is_ignore_null

Gets the is_ignore_null of this LoadSqlTuningSetDetails.

load_option

Gets the load_option of this LoadSqlTuningSetDetails. Specifies which statements are loaded into the Sql tuning set. The possible values are. - INSERT (default) Adds only new statements. - UPDATE Updates existing the Sql statements and ignores any new statements. - MERGE Inserts new statements and updates the information of the existing ones.

load_type

[Required] Gets the load_type of this LoadSqlTuningSetDetails.

name

[Required] Gets the name of this LoadSqlTuningSetDetails.

owner

Gets the owner of this LoadSqlTuningSetDetails.

ranking_measure1

Gets the ranking_measure1 of this LoadSqlTuningSetDetails.

ranking_measure2

Gets the ranking_measure2 of this LoadSqlTuningSetDetails.

ranking_measure3

Gets the ranking_measure3 of this LoadSqlTuningSetDetails.

recursive_sql

Gets the recursive_sql of this LoadSqlTuningSetDetails.

repeat_interval

Gets the repeat_interval of this LoadSqlTuningSetDetails.

result_limit

Gets the result_limit of this LoadSqlTuningSetDetails.

result_percentage

Gets the result_percentage of this LoadSqlTuningSetDetails.

show_sql_only

Gets the show_sql_only of this LoadSqlTuningSetDetails.

total_time_limit

Gets the total_time_limit of this LoadSqlTuningSetDetails.

update_attributes

Gets the update_attributes of this LoadSqlTuningSetDetails. Specifies the list of Sql statement attributes to update during a merge or update. Note that this parameter cannot be made an enum since custom value can take a list of comma separated attribute names. Update attributes can take one of the following values. NULL (default) - Specifies the content of the input cursor except the execution context. On other terms, it is equivalent to ALL without execution contexts such as module and action. BASIC - Specifies statistics and binds only. TYPICAL - Specifies BASIC with Sql plans (without row source statistics) and without an object reference list. ALL - Specifies all attributes, including the execution context attributes such as module and action. CUSTOM - List of comma separated attribute names to update EXECUTION_CONTEXT EXECUTION_STATISTICS SQL_BINDS SQL_PLAN SQL_PLAN_STATISTICS (similar to SQL_PLAN with added row source statistics) Usage examples: 1. "updateAttributes": "TYPICAL" 2. "updateAttributes": "BASIC" 3. "updateAttributes": "EXECUTION_STATISTICS,SQL_PLAN_STATISTICS,SQL_PLAN" 4. "updateAttributes": "EXECUTION_STATISTICS,SQL_PLAN".

update_condition

Gets the update_condition of this LoadSqlTuningSetDetails.

update_option

Gets the update_option of this LoadSqlTuningSetDetails. Specifies how existing Sql statements are updated. This parameter is applicable only if load_option is specified with UPDATE or MERGE as an option. Update option can take one of the following values. REPLACE (default) - Updates the statement using the new statistics, bind list, object list, and so on. ACCUMULATE - Combines attributes when possible (for example, statistics such as elapsed_time), otherwise replaces the existing values (for example, module and action) with the provided values. Following Sql statement attributes can be accumulated. elapsed_time buffer_gets direct_writes disk_reads row_processed fetches executions end_of_fetch_count stat_period active_stat_period.

Methods:

__init__(**kwargs)

Initializes a new LoadSqlTuningSetDetails object with values from keyword arguments.

CAPTURE_MODE_MODE_ACCUMULATE_STATS = 'MODE_ACCUMULATE_STATS'

A constant which can be used with the capture_mode property of a LoadSqlTuningSetDetails. This constant has a value of “MODE_ACCUMULATE_STATS”

CAPTURE_MODE_MODE_REPLACE_OLD_STATS = 'MODE_REPLACE_OLD_STATS'

A constant which can be used with the capture_mode property of a LoadSqlTuningSetDetails. This constant has a value of “MODE_REPLACE_OLD_STATS”

CAPTURE_OPTION_INSERT = 'INSERT'

A constant which can be used with the capture_option property of a LoadSqlTuningSetDetails. This constant has a value of “INSERT”

CAPTURE_OPTION_MERGE = 'MERGE'

A constant which can be used with the capture_option property of a LoadSqlTuningSetDetails. This constant has a value of “MERGE”

CAPTURE_OPTION_UPDATE = 'UPDATE'

A constant which can be used with the capture_option property of a LoadSqlTuningSetDetails. This constant has a value of “UPDATE”

LOAD_OPTION_INSERT = 'INSERT'

A constant which can be used with the load_option property of a LoadSqlTuningSetDetails. This constant has a value of “INSERT”

LOAD_OPTION_MERGE = 'MERGE'

A constant which can be used with the load_option property of a LoadSqlTuningSetDetails. This constant has a value of “MERGE”

LOAD_OPTION_UPDATE = 'UPDATE'

A constant which can be used with the load_option property of a LoadSqlTuningSetDetails. This constant has a value of “UPDATE”

LOAD_TYPE_AWR = 'AWR'

A constant which can be used with the load_type property of a LoadSqlTuningSetDetails. This constant has a value of “AWR”

LOAD_TYPE_CURRENT_CURSOR_CACHE = 'CURRENT_CURSOR_CACHE'

A constant which can be used with the load_type property of a LoadSqlTuningSetDetails. This constant has a value of “CURRENT_CURSOR_CACHE”

LOAD_TYPE_INCREMENTAL_CURSOR_CACHE = 'INCREMENTAL_CURSOR_CACHE'

A constant which can be used with the load_type property of a LoadSqlTuningSetDetails. This constant has a value of “INCREMENTAL_CURSOR_CACHE”

RANKING_MEASURE1_BUFFER_GETS = 'BUFFER_GETS'

A constant which can be used with the ranking_measure1 property of a LoadSqlTuningSetDetails. This constant has a value of “BUFFER_GETS”

RANKING_MEASURE1_CPU_TIME = 'CPU_TIME'

A constant which can be used with the ranking_measure1 property of a LoadSqlTuningSetDetails. This constant has a value of “CPU_TIME”

RANKING_MEASURE1_DIRECT_WRITES = 'DIRECT_WRITES'

A constant which can be used with the ranking_measure1 property of a LoadSqlTuningSetDetails. This constant has a value of “DIRECT_WRITES”

RANKING_MEASURE1_DISK_READS = 'DISK_READS'

A constant which can be used with the ranking_measure1 property of a LoadSqlTuningSetDetails. This constant has a value of “DISK_READS”

RANKING_MEASURE1_ELAPSED_TIME = 'ELAPSED_TIME'

A constant which can be used with the ranking_measure1 property of a LoadSqlTuningSetDetails. This constant has a value of “ELAPSED_TIME”

RANKING_MEASURE1_OPTIMIZER_COST = 'OPTIMIZER_COST'

A constant which can be used with the ranking_measure1 property of a LoadSqlTuningSetDetails. This constant has a value of “OPTIMIZER_COST”

RANKING_MEASURE2_BUFFER_GETS = 'BUFFER_GETS'

A constant which can be used with the ranking_measure2 property of a LoadSqlTuningSetDetails. This constant has a value of “BUFFER_GETS”

RANKING_MEASURE2_CPU_TIME = 'CPU_TIME'

A constant which can be used with the ranking_measure2 property of a LoadSqlTuningSetDetails. This constant has a value of “CPU_TIME”

RANKING_MEASURE2_DIRECT_WRITES = 'DIRECT_WRITES'

A constant which can be used with the ranking_measure2 property of a LoadSqlTuningSetDetails. This constant has a value of “DIRECT_WRITES”

RANKING_MEASURE2_DISK_READS = 'DISK_READS'

A constant which can be used with the ranking_measure2 property of a LoadSqlTuningSetDetails. This constant has a value of “DISK_READS”

RANKING_MEASURE2_ELAPSED_TIME = 'ELAPSED_TIME'

A constant which can be used with the ranking_measure2 property of a LoadSqlTuningSetDetails. This constant has a value of “ELAPSED_TIME”

RANKING_MEASURE2_OPTIMIZER_COST = 'OPTIMIZER_COST'

A constant which can be used with the ranking_measure2 property of a LoadSqlTuningSetDetails. This constant has a value of “OPTIMIZER_COST”

RANKING_MEASURE3_BUFFER_GETS = 'BUFFER_GETS'

A constant which can be used with the ranking_measure3 property of a LoadSqlTuningSetDetails. This constant has a value of “BUFFER_GETS”

RANKING_MEASURE3_CPU_TIME = 'CPU_TIME'

A constant which can be used with the ranking_measure3 property of a LoadSqlTuningSetDetails. This constant has a value of “CPU_TIME”

RANKING_MEASURE3_DIRECT_WRITES = 'DIRECT_WRITES'

A constant which can be used with the ranking_measure3 property of a LoadSqlTuningSetDetails. This constant has a value of “DIRECT_WRITES”

RANKING_MEASURE3_DISK_READS = 'DISK_READS'

A constant which can be used with the ranking_measure3 property of a LoadSqlTuningSetDetails. This constant has a value of “DISK_READS”

RANKING_MEASURE3_ELAPSED_TIME = 'ELAPSED_TIME'

A constant which can be used with the ranking_measure3 property of a LoadSqlTuningSetDetails. This constant has a value of “ELAPSED_TIME”

RANKING_MEASURE3_OPTIMIZER_COST = 'OPTIMIZER_COST'

A constant which can be used with the ranking_measure3 property of a LoadSqlTuningSetDetails. This constant has a value of “OPTIMIZER_COST”

RECURSIVE_SQL_HAS_RECURSIVE_SQL = 'HAS_RECURSIVE_SQL'

A constant which can be used with the recursive_sql property of a LoadSqlTuningSetDetails. This constant has a value of “HAS_RECURSIVE_SQL”

RECURSIVE_SQL_NO_RECURSIVE_SQL = 'NO_RECURSIVE_SQL'

A constant which can be used with the recursive_sql property of a LoadSqlTuningSetDetails. This constant has a value of “NO_RECURSIVE_SQL”

UPDATE_CONDITION_NEW = 'NEW'

A constant which can be used with the update_condition property of a LoadSqlTuningSetDetails. This constant has a value of “NEW”

UPDATE_CONDITION_NULL = 'NULL'

A constant which can be used with the update_condition property of a LoadSqlTuningSetDetails. This constant has a value of “NULL”

UPDATE_CONDITION_OLD = 'OLD'

A constant which can be used with the update_condition property of a LoadSqlTuningSetDetails. This constant has a value of “OLD”

UPDATE_OPTION_ACCUMULATE = 'ACCUMULATE'

A constant which can be used with the update_option property of a LoadSqlTuningSetDetails. This constant has a value of “ACCUMULATE”

UPDATE_OPTION_REPLACE = 'REPLACE'

A constant which can be used with the update_option property of a LoadSqlTuningSetDetails. This constant has a value of “REPLACE”

__init__(**kwargs)

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

Parameters
  • credential_details (oci.database_management.models.SqlTuningSetAdminCredentialDetails) – The value to assign to the credential_details property of this LoadSqlTuningSetDetails.

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

  • show_sql_only (int) – The value to assign to the show_sql_only property of this LoadSqlTuningSetDetails.

  • owner (str) – The value to assign to the owner property of this LoadSqlTuningSetDetails.

  • name (str) – The value to assign to the name property of this LoadSqlTuningSetDetails.

  • load_type (str) – The value to assign to the load_type property of this LoadSqlTuningSetDetails. Allowed values for this property are: “INCREMENTAL_CURSOR_CACHE”, “CURRENT_CURSOR_CACHE”, “AWR”

  • basic_filter (str) – The value to assign to the basic_filter property of this LoadSqlTuningSetDetails.

  • recursive_sql (str) – The value to assign to the recursive_sql property of this LoadSqlTuningSetDetails. Allowed values for this property are: “HAS_RECURSIVE_SQL”, “NO_RECURSIVE_SQL”

  • result_percentage (float) – The value to assign to the result_percentage property of this LoadSqlTuningSetDetails.

  • result_limit (int) – The value to assign to the result_limit property of this LoadSqlTuningSetDetails.

  • ranking_measure1 (str) – The value to assign to the ranking_measure1 property of this LoadSqlTuningSetDetails. Allowed values for this property are: “ELAPSED_TIME”, “CPU_TIME”, “OPTIMIZER_COST”, “BUFFER_GETS”, “DISK_READS”, “DIRECT_WRITES”

  • ranking_measure2 (str) – The value to assign to the ranking_measure2 property of this LoadSqlTuningSetDetails. Allowed values for this property are: “ELAPSED_TIME”, “CPU_TIME”, “OPTIMIZER_COST”, “BUFFER_GETS”, “DISK_READS”, “DIRECT_WRITES”

  • ranking_measure3 (str) – The value to assign to the ranking_measure3 property of this LoadSqlTuningSetDetails. Allowed values for this property are: “ELAPSED_TIME”, “CPU_TIME”, “OPTIMIZER_COST”, “BUFFER_GETS”, “DISK_READS”, “DIRECT_WRITES”

  • total_time_limit (int) – The value to assign to the total_time_limit property of this LoadSqlTuningSetDetails.

  • repeat_interval (int) – The value to assign to the repeat_interval property of this LoadSqlTuningSetDetails.

  • capture_option (str) – The value to assign to the capture_option property of this LoadSqlTuningSetDetails. Allowed values for this property are: “INSERT”, “UPDATE”, “MERGE”

  • capture_mode (str) – The value to assign to the capture_mode property of this LoadSqlTuningSetDetails. Allowed values for this property are: “MODE_REPLACE_OLD_STATS”, “MODE_ACCUMULATE_STATS”

  • attribute_list (str) – The value to assign to the attribute_list property of this LoadSqlTuningSetDetails.

  • load_option (str) – The value to assign to the load_option property of this LoadSqlTuningSetDetails. Allowed values for this property are: “INSERT”, “UPDATE”, “MERGE”

  • update_option (str) – The value to assign to the update_option property of this LoadSqlTuningSetDetails. Allowed values for this property are: “REPLACE”, “ACCUMULATE”

  • update_attributes (str) – The value to assign to the update_attributes property of this LoadSqlTuningSetDetails.

  • update_condition (str) – The value to assign to the update_condition property of this LoadSqlTuningSetDetails. Allowed values for this property are: “OLD”, “NEW”, “NULL”

  • is_ignore_null (bool) – The value to assign to the is_ignore_null property of this LoadSqlTuningSetDetails.

  • commit_rows (int) – The value to assign to the commit_rows property of this LoadSqlTuningSetDetails.

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

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

  • baseline_name (str) – The value to assign to the baseline_name property of this LoadSqlTuningSetDetails.

property attribute_list

Gets the attribute_list of this LoadSqlTuningSetDetails. Specifies the list of Sql statement attributes to return in the result. Note that this parameter cannot be made an enum since custom value can take a list of comma separated attribute names. Attribute list can take one of the following values.

TYPICAL - Specifies BASIC plus Sql plan (without row source statistics) and without object reference list (default). BASIC - Specifies all attributes (such as execution statistics and binds) except the plans. The execution context is always part of the result. ALL - Specifies all attributes. CUSTOM - Comma-separated list of the following attribute names.

  • EXECUTION_STATISTICS

  • BIND_LIST

  • OBJECT_LIST

  • SQL_PLAN

  • SQL_PLAN_STATISTICS

Usage examples:
  1. “attributeList”: “TYPICAL”

  2. “attributeList”: “ALL”

  3. “attributeList”: “EXECUTION_STATISTICS,OBJECT_LIST,SQL_PLAN”

Returns

The attribute_list of this LoadSqlTuningSetDetails.

Return type

str

property baseline_name

Gets the baseline_name of this LoadSqlTuningSetDetails. Specifies the name of the AWR baseline period. When loading the sql statements from AWR, following inputs has to be provided: beginSnapshot and endSnapshot OR baselineName

Returns

The baseline_name of this LoadSqlTuningSetDetails.

Return type

str

property basic_filter

Gets the basic_filter of this LoadSqlTuningSetDetails. Specifies the Sql predicate to filter the Sql from the Sql tuning set defined on attributes of the SQLSET_ROW. User could use any combination of the following columns with appropriate values as Sql predicate Refer to the documentation https://docs.oracle.com/en/database/oracle/oracle-database/18/arpls/DBMS_SQLTUNE.html#GUID-1F4AFB03-7B29-46FC-B3F2-CB01EC36326C

Returns

The basic_filter of this LoadSqlTuningSetDetails.

Return type

str

property begin_snapshot

Gets the begin_snapshot of this LoadSqlTuningSetDetails. Defines the beginning AWR snapshot (non-inclusive).

Returns

The begin_snapshot of this LoadSqlTuningSetDetails.

Return type

int

property capture_mode

Gets the capture_mode of this LoadSqlTuningSetDetails. Specifies the capture mode. Note that this parameter is applicable only for UPDATE and MERGE capture options. Capture mode can take one of the following values

  • MODE_REPLACE_OLD_STATS

    Replaces statistics when the number of executions is greater than the number stored in the Sql tuning set

  • MODE_ACCUMULATE_STATS

    Adds new values to current values for Sql that is already stored. Note that this mode detects if a statement has been aged out, so the final value for a statistics is the sum of the statistics of all cursors that statement existed under.

Allowed values for this property are: “MODE_REPLACE_OLD_STATS”, “MODE_ACCUMULATE_STATS”

Returns

The capture_mode of this LoadSqlTuningSetDetails.

Return type

str

property capture_option

Gets the capture_option of this LoadSqlTuningSetDetails. Specifies whether to insert new statements, update existing statements, or both.

Allowed values for this property are: “INSERT”, “UPDATE”, “MERGE”

Returns

The capture_option of this LoadSqlTuningSetDetails.

Return type

str

property commit_rows

Gets the commit_rows of this LoadSqlTuningSetDetails. Specifies whether to commit statements after DML. If a value is provided, then the load commits after each specified number of statements is inserted. If NULL is provided, then the load commits only once, at the end of the operation.

Returns

The commit_rows of this LoadSqlTuningSetDetails.

Return type

int

property credential_details

Gets the credential_details of this LoadSqlTuningSetDetails.

Returns

The credential_details of this LoadSqlTuningSetDetails.

Return type

oci.database_management.models.SqlTuningSetAdminCredentialDetails

property database_credential

Gets the database_credential of this LoadSqlTuningSetDetails.

Returns

The database_credential of this LoadSqlTuningSetDetails.

Return type

oci.database_management.models.DatabaseCredentialDetails

property end_snapshot

Gets the end_snapshot of this LoadSqlTuningSetDetails. Defines the ending AWR snapshot (inclusive).

Returns

The end_snapshot of this LoadSqlTuningSetDetails.

Return type

int

property is_ignore_null

Gets the is_ignore_null of this LoadSqlTuningSetDetails. Specifies whether to update attributes when the new value is NULL. If TRUE, then the procedure does not update an attribute when the new value is NULL. That is, do not override with NULL values unless intentional. Possible values - true or false

Returns

The is_ignore_null of this LoadSqlTuningSetDetails.

Return type

bool

property load_option

Gets the load_option of this LoadSqlTuningSetDetails. Specifies which statements are loaded into the Sql tuning set. The possible values are.

  • INSERT (default)

    Adds only new statements.

  • UPDATE

    Updates existing the Sql statements and ignores any new statements.

  • MERGE

    Inserts new statements and updates the information of the existing ones.

Allowed values for this property are: “INSERT”, “UPDATE”, “MERGE”

Returns

The load_option of this LoadSqlTuningSetDetails.

Return type

str

property load_type

[Required] Gets the load_type of this LoadSqlTuningSetDetails. Specifies the loading method into the Sql tuning set.

Allowed values for this property are: “INCREMENTAL_CURSOR_CACHE”, “CURRENT_CURSOR_CACHE”, “AWR”

Returns

The load_type of this LoadSqlTuningSetDetails.

Return type

str

property name

[Required] Gets the name of this LoadSqlTuningSetDetails. The name of the Sql tuning set.

Returns

The name of this LoadSqlTuningSetDetails.

Return type

str

property owner

Gets the owner of this LoadSqlTuningSetDetails. The owner of the Sql tuning set.

Returns

The owner of this LoadSqlTuningSetDetails.

Return type

str

property ranking_measure1

Gets the ranking_measure1 of this LoadSqlTuningSetDetails. Specifies an ORDER BY clause on the selected Sql. User can specify upto three ranking measures.

Allowed values for this property are: “ELAPSED_TIME”, “CPU_TIME”, “OPTIMIZER_COST”, “BUFFER_GETS”, “DISK_READS”, “DIRECT_WRITES”

Returns

The ranking_measure1 of this LoadSqlTuningSetDetails.

Return type

str

property ranking_measure2

Gets the ranking_measure2 of this LoadSqlTuningSetDetails. Specifies an ORDER BY clause on the selected Sql. User can specify upto three ranking measures.

Allowed values for this property are: “ELAPSED_TIME”, “CPU_TIME”, “OPTIMIZER_COST”, “BUFFER_GETS”, “DISK_READS”, “DIRECT_WRITES”

Returns

The ranking_measure2 of this LoadSqlTuningSetDetails.

Return type

str

property ranking_measure3

Gets the ranking_measure3 of this LoadSqlTuningSetDetails. Specifies an ORDER BY clause on the selected Sql. User can specify upto three ranking measures.

Allowed values for this property are: “ELAPSED_TIME”, “CPU_TIME”, “OPTIMIZER_COST”, “BUFFER_GETS”, “DISK_READS”, “DIRECT_WRITES”

Returns

The ranking_measure3 of this LoadSqlTuningSetDetails.

Return type

str

property recursive_sql

Gets the recursive_sql of this LoadSqlTuningSetDetails. Specifies that the filter must include recursive Sql in the Sql tuning set.

Allowed values for this property are: “HAS_RECURSIVE_SQL”, “NO_RECURSIVE_SQL”

Returns

The recursive_sql of this LoadSqlTuningSetDetails.

Return type

str

property repeat_interval

Gets the repeat_interval of this LoadSqlTuningSetDetails. Defines the amount of time, in seconds, to pause between sampling.

Returns

The repeat_interval of this LoadSqlTuningSetDetails.

Return type

int

property result_limit

Gets the result_limit of this LoadSqlTuningSetDetails. The top limit Sql from the filtered source, ranked by the ranking measure.

Returns

The result_limit of this LoadSqlTuningSetDetails.

Return type

int

property result_percentage

Gets the result_percentage of this LoadSqlTuningSetDetails. Specifies a filter that picks the top n% according to the supplied ranking measure. Note that this parameter applies only if one ranking measure is supplied.

Returns

The result_percentage of this LoadSqlTuningSetDetails.

Return type

float

property show_sql_only

Gets the show_sql_only of this LoadSqlTuningSetDetails. Flag to indicate whether to create the Sql tuning set or just display the plsql used to create Sql tuning set.

Returns

The show_sql_only of this LoadSqlTuningSetDetails.

Return type

int

property total_time_limit

Gets the total_time_limit of this LoadSqlTuningSetDetails. Defines the total amount of time, in seconds, to execute.

Returns

The total_time_limit of this LoadSqlTuningSetDetails.

Return type

int

property update_attributes

Gets the update_attributes of this LoadSqlTuningSetDetails. Specifies the list of Sql statement attributes to update during a merge or update. Note that this parameter cannot be made an enum since custom value can take a list of comma separated attribute names. Update attributes can take one of the following values.

NULL (default) - Specifies the content of the input cursor except the execution context. On other terms, it is equivalent to ALL without execution contexts such as module and action. BASIC - Specifies statistics and binds only. TYPICAL - Specifies BASIC with Sql plans (without row source statistics) and without an object reference list. ALL - Specifies all attributes, including the execution context attributes such as module and action. CUSTOM - List of comma separated attribute names to update

EXECUTION_CONTEXT EXECUTION_STATISTICS SQL_BINDS SQL_PLAN SQL_PLAN_STATISTICS (similar to SQL_PLAN with added row source statistics)

Usage examples:
  1. “updateAttributes”: “TYPICAL”

  2. “updateAttributes”: “BASIC”

  3. “updateAttributes”: “EXECUTION_STATISTICS,SQL_PLAN_STATISTICS,SQL_PLAN”

  4. “updateAttributes”: “EXECUTION_STATISTICS,SQL_PLAN”

Returns

The update_attributes of this LoadSqlTuningSetDetails.

Return type

str

property update_condition

Gets the update_condition of this LoadSqlTuningSetDetails. Specifies when to perform the update. The procedure only performs the update when the specified condition is satisfied. The condition can refer to either the data source or destination. The condition must use the following prefixes to refer to attributes from the source or the destination: OLD — Refers to statement attributes from the SQL tuning set (destination). NEW — Refers to statement attributes from the input statements (source). NULL — No updates are performed.

Allowed values for this property are: “OLD”, “NEW”, “NULL”

Returns

The update_condition of this LoadSqlTuningSetDetails.

Return type

str

property update_option

Gets the update_option of this LoadSqlTuningSetDetails. Specifies how existing Sql statements are updated. This parameter is applicable only if load_option is specified with UPDATE or MERGE as an option. Update option can take one of the following values.

REPLACE (default) - Updates the statement using the new statistics, bind list, object list, and so on. ACCUMULATE - Combines attributes when possible (for example, statistics such as elapsed_time), otherwise replaces the existing values (for example, module and action) with the provided values. Following Sql statement attributes can be accumulated.

elapsed_time buffer_gets direct_writes disk_reads row_processed fetches executions end_of_fetch_count stat_period active_stat_period

Allowed values for this property are: “REPLACE”, “ACCUMULATE”

Returns

The update_option of this LoadSqlTuningSetDetails.

Return type

str