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”

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

credential_details¶

Gets the credential_details of this FetchSqlTuningSetDetails.

Returns:	The credential_details of this FetchSqlTuningSetDetails.
Return type:	oci.database_management.models.SqlTuningSetAdminCredentialDetails

database_credential¶

Gets the database_credential of this FetchSqlTuningSetDetails.

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

name¶

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

Returns:	The name of this FetchSqlTuningSetDetails.
Return type:	str

owner¶

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

Returns:	The owner of this FetchSqlTuningSetDetails.
Return type:	str

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

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

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

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

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

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