Lists the SQL Tuning Sets.
GET {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlTuningSets?owner=<string>&nameContains=<string>&sortBy=NAME&sortOrder=ASC&page=<string>&limit=10
Lists the SQL tuning sets for the specified Managed Database.
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
owner | string | The owner of the SQL tuning set. | |
nameContains | string | Allow searching the name of the SQL tuning set by partial matching. The search is case insensitive. | |
sortBy | string | The option to sort the SQL tuning set summary data. | |
sortOrder | string | The option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Ascending order is the default order. | |
page | 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. | |||
limit | number | The maximum number of records returned in the paginated response. |
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
opc-named-credential-id | string | The OCID of the Named Credential. | |
Accept | string |
RESPONSES
status: OK
{"managedDatabaseId":"\u003cstring\u003e","items":[{"name":"\u003cstring\u003e","owner":"\u003cstring\u003e","description":"\u003cstring\u003e","errorMessage":"\u003cstring\u003e","id":"\u003cinteger\u003e","scheduledJobName":"\u003cstring\u003e","statementCounts":"\u003cinteger\u003e","status":"COMPLETED","timeCreated":"\u003cdateTime\u003e","timeLastModified":"\u003cdateTime\u003e"},{"name":"\u003cstring\u003e","owner":"\u003cstring\u003e","description":"\u003cstring\u003e","errorMessage":"\u003cstring\u003e","id":"\u003cinteger\u003e","scheduledJobName":"\u003cstring\u003e","statementCounts":"\u003cinteger\u003e","status":"BLOCKED","timeCreated":"\u003cdateTime\u003e","timeLastModified":"\u003cdateTime\u003e"}]}