Lists the SQL plan baselines.
GET {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlPlanBaselines?planName=<string>&sqlHandle=<string>&sqlText=<string>&isEnabled=<boolean>&isAccepted=<boolean>&isReproduced=<boolean>&isFixed=<boolean>&isAdaptive=<boolean>&origin=MANUAL_LOAD_FROM_AWR&page=<string>&limit=10&sortBy=timeCreated&sortOrder=DESC&isAutoPurged=<boolean>&timeLastExecutedGreaterThan=<dateTime>&timeLastExecutedLessThan=<dateTime>&isNeverExecuted=false
Lists the SQL plan baselines for the specified Managed Database.
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
planName | string | A filter to return only SQL plan baselines that match the plan name. | |
sqlHandle | string | A filter to return all the SQL plan baselines for the specified SQL handle. | |
sqlText | string | A filter to return all the SQL plan baselines that match the SQL text. By default, the search | |
is case insensitive. To run an exact or case-sensitive search, double-quote the search string. | |||
You may also use the '%' symbol as a wildcard. | |||
isEnabled | string | A filter to return only SQL plan baselines that are either enabled or not enabled. | |
By default, all SQL plan baselines are returned. | |||
isAccepted | string | A filter to return only SQL plan baselines that are either accepted or not accepted. | |
By default, all SQL plan baselines are returned. | |||
isReproduced | string | A filter to return only SQL plan baselines that were either reproduced or | |
not reproduced by the optimizer. By default, all SQL plan baselines are returned. | |||
isFixed | string | A filter to return only SQL plan baselines that are either fixed or not fixed. | |
By default, all SQL plan baselines are returned. | |||
isAdaptive | string | A filter to return only SQL plan baselines that are either adaptive or not adaptive. | |
By default, all SQL plan baselines are returned. | |||
origin | string | A filter to return all the SQL plan baselines that match the origin. | |
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. | |
sortBy | string | The option to sort the SQL plan baseline summary data. | |
sortOrder | string | The option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Descending order is the default order. | |
isAutoPurged | string | A filter to return only SQL plan baselines that are either auto-purged or not auto-purged. | |
By default, all SQL plan baselines are returned. | |||
timeLastExecutedGreaterThan | string | A filter to return only SQL plan baselines whose last execution time is | |
after the specified value. By default, all SQL plan baselines are returned. | |||
timeLastExecutedLessThan | string | A filter to return only SQL plan baselines whose last execution time is | |
before the specified value. By default, all SQL plan baselines are returned. | |||
isNeverExecuted | boolean | A filter to return only SQL plan baselines that are not executed till now. | |
By default, all SQL plan baselines are returned. | |||
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
{"items":[{"planName":"\u003cstring\u003e","sqlHandle":"\u003cstring\u003e","sqlText":"\u003cstring\u003e","timeCreated":"\u003cdateTime\u003e","accepted":"YES","adaptive":"NO","autoPurge":"NO","enabled":"NO","fixed":"YES","origin":"MANUAL_SQLTUNE","reproduced":"YES","timeLastExecuted":"\u003cdateTime\u003e","timeLastModified":"\u003cdateTime\u003e"},{"planName":"\u003cstring\u003e","sqlHandle":"\u003cstring\u003e","sqlText":"\u003cstring\u003e","timeCreated":"\u003cdateTime\u003e","accepted":"YES","adaptive":"NO","autoPurge":"NO","enabled":"YES","fixed":"YES","origin":"MANUAL_LOAD_FROM_AWR","reproduced":"YES","timeLastExecuted":"\u003cdateTime\u003e","timeLastModified":"\u003cdateTime\u003e"}]}