FetchSqlTuningSetDetails

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

Bases: object

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

Attributes:

RANKING_MEASURE1_BUFFER_GETS

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

RANKING_MEASURE1_CPU_TIME

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

RANKING_MEASURE1_DIRECT_WRITES

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

RANKING_MEASURE1_DISK_READS

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

RANKING_MEASURE1_ELAPSED_TIME

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

RANKING_MEASURE1_OPTIMIZER_COST

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

RANKING_MEASURE2_BUFFER_GETS

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

RANKING_MEASURE2_CPU_TIME

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

RANKING_MEASURE2_DIRECT_WRITES

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

RANKING_MEASURE2_DISK_READS

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

RANKING_MEASURE2_ELAPSED_TIME

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

RANKING_MEASURE2_OPTIMIZER_COST

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

RANKING_MEASURE3_BUFFER_GETS

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

RANKING_MEASURE3_CPU_TIME

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

RANKING_MEASURE3_DIRECT_WRITES

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

RANKING_MEASURE3_DISK_READS

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

RANKING_MEASURE3_ELAPSED_TIME

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

RANKING_MEASURE3_OPTIMIZER_COST

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

RECURSIVE_SQL_HAS_RECURSIVE_SQL

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

RECURSIVE_SQL_NO_RECURSIVE_SQL

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

basic_filter

Gets the basic_filter of this FetchSqlTuningSetDetails.

credential_details

Gets the credential_details of this FetchSqlTuningSetDetails.

database_credential

Gets the database_credential of this FetchSqlTuningSetDetails.

name

[Required] Gets the name of this FetchSqlTuningSetDetails.

owner

[Required] Gets the owner of this FetchSqlTuningSetDetails.

ranking_measure1

Gets the ranking_measure1 of this FetchSqlTuningSetDetails.

ranking_measure2

Gets the ranking_measure2 of this FetchSqlTuningSetDetails.

ranking_measure3

Gets the ranking_measure3 of this FetchSqlTuningSetDetails.

recursive_sql

Gets the recursive_sql of this FetchSqlTuningSetDetails.

result_limit

Gets the result_limit of this FetchSqlTuningSetDetails.

result_percentage

Gets the result_percentage of this FetchSqlTuningSetDetails.

Methods:

__init__(**kwargs)

Initializes a new FetchSqlTuningSetDetails object with values from keyword arguments.

RANKING_MEASURE1_BUFFER_GETS = 'BUFFER_GETS'

A constant which can be used with the ranking_measure1 property of a FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. This constant has a value of “NO_RECURSIVE_SQL”

__init__(**kwargs)

Initializes a new FetchSqlTuningSetDetails 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 FetchSqlTuningSetDetails.

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

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

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

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

  • recursive_sql (str) – The value to assign to the recursive_sql property of this FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails.

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

  • ranking_measure1 (str) – The value to assign to the ranking_measure1 property of this FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails. Allowed values for this property are: “ELAPSED_TIME”, “CPU_TIME”, “OPTIMIZER_COST”, “BUFFER_GETS”, “DISK_READS”, “DIRECT_WRITES”

property basic_filter

Gets the basic_filter of this FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails.

Return type

str

property credential_details

Gets the credential_details of this FetchSqlTuningSetDetails.

Returns

The credential_details of this FetchSqlTuningSetDetails.

Return type

oci.database_management.models.SqlTuningSetAdminCredentialDetails

property database_credential

Gets the database_credential of this FetchSqlTuningSetDetails.

Returns

The database_credential of this FetchSqlTuningSetDetails.

Return type

oci.database_management.models.DatabaseCredentialDetails

property name

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

Returns

The name of this FetchSqlTuningSetDetails.

Return type

str

property owner

[Required] Gets the owner of this FetchSqlTuningSetDetails. The owner of the Sql tuning set.

Returns

The owner of this FetchSqlTuningSetDetails.

Return type

str

property ranking_measure1

Gets the ranking_measure1 of this FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails.

Return type

str

property ranking_measure2

Gets the ranking_measure2 of this FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails.

Return type

str

property ranking_measure3

Gets the ranking_measure3 of this FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails.

Return type

str

property recursive_sql

Gets the recursive_sql of this FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails.

Return type

str

property result_limit

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

Returns

The result_limit of this FetchSqlTuningSetDetails.

Return type

int

property result_percentage

Gets the result_percentage of this FetchSqlTuningSetDetails. 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 FetchSqlTuningSetDetails.

Return type

float