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
The name of the Sql tuning set.
The owner of the Sql tuning set.
Specifies an ORDER BY clause on the selected Sql. User can specify upto three ranking measures.
Specifies an ORDER BY clause on the selected Sql. User can specify upto three ranking measures.
Specifies an ORDER BY clause on the selected Sql. User can specify upto three ranking measures.
Specifies that the filter must include recursive Sql in the Sql tuning set.
The top limit Sql from the filtered source, ranked by the ranking measure. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
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. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
The details required to fetch the Sql tuning set details. It takes either credentialDetails or databaseCredential. It's recommended to provide databaseCredential