Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace ListSqlTuningAdvisorTaskFindingsRequest

example

Click here to see how to use ListSqlTuningAdvisorTaskFindingsRequest.

Properties

Optional beginExecId

beginExecId: undefined | number

The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task.

Optional endExecId

endExecId: undefined | number

The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task.

Optional findingFilter

findingFilter: FindingFilter

The filter used to display specific findings in the report.

Optional indexHashFilter

indexHashFilter: undefined | string

The hash value of the index table name.

Optional limit

limit: undefined | number

The maximum number of records returned in the paginated response.

managedDatabaseId

managedDatabaseId: string

The OCID of the Managed Database.

Optional opcNamedCredentialId

opcNamedCredentialId: undefined | string

The OCID of the Named Credential.

Optional opcRequestId

opcRequestId: undefined | string

The client request ID for tracing.

Optional page

page: undefined | string

The page token representing the page from where the next set of paginated results are retrieved. This is usually retrieved from a previous list call.

Optional retryConfiguration

retryConfiguration: RetryConfiguration

RetryConfiguration to be used for the request NOTE : Retries are not supported for requests that have binary or stream bodies this also affects UploadManager operations For all requests with binary/stream bodies, retry attempts are not made

Optional searchPeriod

searchPeriod: SearchPeriod

The search period during which the API will search for begin and end exec id, if not supplied. Unused if beginExecId and endExecId optional query params are both supplied.

Optional sortBy

sortBy: SortBy

The possible sortBy values of an object's recommendations.

Optional sortOrder

sortOrder: model.SortOrders

The option to sort information in ascending (\u2018ASC\u2019) or descending (\u2018DESC\u2019) order. Descending order is the default order.

sqlTuningAdvisorTaskId

sqlTuningAdvisorTaskId: number

The SQL tuning task identifier. This is not the OCID.

Optional statsHashFilter

statsHashFilter: undefined | string

The hash value of the object for the statistic finding search.