Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace FetchSqlTuningSetDetails

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

Enumerations

Properties

Functions

Properties

Optional basicFilter

basicFilter: undefined | string

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

Optional credentialDetails

credentialDetails: SqlTuningSetAdminPasswordCredentialDetails | SqlTuningSetAdminSecretCredentialDetails

Optional databaseCredential

databaseCredential: DatabaseSecretCredentialDetails | DatabaseNamedCredentialDetails | DatabasePasswordCredentialDetails

name

name: string

The name of the Sql tuning set.

owner

owner: string

The owner of the Sql tuning set.

Optional rankingMeasure1

rankingMeasure1: model.RankingMeasure

Specifies an ORDER BY clause on the selected Sql. User can specify upto three ranking measures.

Optional rankingMeasure2

rankingMeasure2: model.RankingMeasure

Specifies an ORDER BY clause on the selected Sql. User can specify upto three ranking measures.

Optional rankingMeasure3

rankingMeasure3: model.RankingMeasure

Specifies an ORDER BY clause on the selected Sql. User can specify upto three ranking measures.

Optional recursiveSql

recursiveSql: RecursiveSql

Specifies that the filter must include recursive Sql in the Sql tuning set.

Optional resultLimit

resultLimit: undefined | number

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.

Optional resultPercentage

resultPercentage: undefined | number

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.

Functions

getDeserializedJsonObj

getJsonObj