FetchSqlTuningSetDetails¶
- class oci.database_management.models.FetchSqlTuningSetDetails(**kwargs)¶
Bases:
objectThe details required to fetch the Sql tuning set details. It takes either credentialDetails or databaseCredential. It’s recommended to provide databaseCredential
Attributes:
A constant which can be used with the ranking_measure1 property of a FetchSqlTuningSetDetails.
A constant which can be used with the ranking_measure1 property of a FetchSqlTuningSetDetails.
A constant which can be used with the ranking_measure1 property of a FetchSqlTuningSetDetails.
A constant which can be used with the ranking_measure1 property of a FetchSqlTuningSetDetails.
A constant which can be used with the ranking_measure1 property of a FetchSqlTuningSetDetails.
A constant which can be used with the ranking_measure1 property of a FetchSqlTuningSetDetails.
A constant which can be used with the ranking_measure2 property of a FetchSqlTuningSetDetails.
A constant which can be used with the ranking_measure2 property of a FetchSqlTuningSetDetails.
A constant which can be used with the ranking_measure2 property of a FetchSqlTuningSetDetails.
A constant which can be used with the ranking_measure2 property of a FetchSqlTuningSetDetails.
A constant which can be used with the ranking_measure2 property of a FetchSqlTuningSetDetails.
A constant which can be used with the ranking_measure2 property of a FetchSqlTuningSetDetails.
A constant which can be used with the ranking_measure3 property of a FetchSqlTuningSetDetails.
A constant which can be used with the ranking_measure3 property of a FetchSqlTuningSetDetails.
A constant which can be used with the ranking_measure3 property of a FetchSqlTuningSetDetails.
A constant which can be used with the ranking_measure3 property of a FetchSqlTuningSetDetails.
A constant which can be used with the ranking_measure3 property of a FetchSqlTuningSetDetails.
A constant which can be used with the ranking_measure3 property of a FetchSqlTuningSetDetails.
A constant which can be used with the recursive_sql property of a FetchSqlTuningSetDetails.
A constant which can be used with the recursive_sql property of a FetchSqlTuningSetDetails.
Gets the basic_filter of this FetchSqlTuningSetDetails.
Gets the credential_details of this FetchSqlTuningSetDetails.
Gets the database_credential of this FetchSqlTuningSetDetails.
[Required] Gets the name of this FetchSqlTuningSetDetails.
[Required] Gets the owner of this FetchSqlTuningSetDetails.
Gets the ranking_measure1 of this FetchSqlTuningSetDetails.
Gets the ranking_measure2 of this FetchSqlTuningSetDetails.
Gets the ranking_measure3 of this FetchSqlTuningSetDetails.
Gets the recursive_sql of this FetchSqlTuningSetDetails.
Gets the result_limit of this FetchSqlTuningSetDetails.
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
- 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