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

KeyDatatypeRequiredDescription
planNamestringA filter to return only SQL plan baselines that match the plan name.
sqlHandlestringA filter to return all the SQL plan baselines for the specified SQL handle.
sqlTextstringA 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.
isEnabledstringA filter to return only SQL plan baselines that are either enabled or not enabled.
By default, all SQL plan baselines are returned.
isAcceptedstringA filter to return only SQL plan baselines that are either accepted or not accepted.
By default, all SQL plan baselines are returned.
isReproducedstringA 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.
isFixedstringA filter to return only SQL plan baselines that are either fixed or not fixed.
By default, all SQL plan baselines are returned.
isAdaptivestringA filter to return only SQL plan baselines that are either adaptive or not adaptive.
By default, all SQL plan baselines are returned.
originstringA filter to return all the SQL plan baselines that match the origin.
pagestringThe page token representing the page from where the next set of paginated results
are retrieved. This is usually retrieved from a previous list call.
limitnumberThe maximum number of records returned in the paginated response.
sortBystringThe option to sort the SQL plan baseline summary data.
sortOrderstringThe option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Descending order is the default order.
isAutoPurgedstringA filter to return only SQL plan baselines that are either auto-purged or not auto-purged.
By default, all SQL plan baselines are returned.
timeLastExecutedGreaterThanstringA filter to return only SQL plan baselines whose last execution time is
after the specified value. By default, all SQL plan baselines are returned.
timeLastExecutedLessThanstringA filter to return only SQL plan baselines whose last execution time is
before the specified value. By default, all SQL plan baselines are returned.
isNeverExecutedbooleanA filter to return only SQL plan baselines that are not executed till now.
By default, all SQL plan baselines are returned.

HEADERS

KeyDatatypeRequiredDescription
opc-request-idstringThe client request ID for tracing.
opc-named-credential-idstringThe OCID of the Named Credential.
Acceptstring

RESPONSES

status: OK

{&quot;items&quot;:[{&quot;planName&quot;:&quot;\u003cstring\u003e&quot;,&quot;sqlHandle&quot;:&quot;\u003cstring\u003e&quot;,&quot;sqlText&quot;:&quot;\u003cstring\u003e&quot;,&quot;timeCreated&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;accepted&quot;:&quot;YES&quot;,&quot;adaptive&quot;:&quot;NO&quot;,&quot;autoPurge&quot;:&quot;NO&quot;,&quot;enabled&quot;:&quot;NO&quot;,&quot;fixed&quot;:&quot;YES&quot;,&quot;origin&quot;:&quot;MANUAL_SQLTUNE&quot;,&quot;reproduced&quot;:&quot;YES&quot;,&quot;timeLastExecuted&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;timeLastModified&quot;:&quot;\u003cdateTime\u003e&quot;},{&quot;planName&quot;:&quot;\u003cstring\u003e&quot;,&quot;sqlHandle&quot;:&quot;\u003cstring\u003e&quot;,&quot;sqlText&quot;:&quot;\u003cstring\u003e&quot;,&quot;timeCreated&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;accepted&quot;:&quot;YES&quot;,&quot;adaptive&quot;:&quot;NO&quot;,&quot;autoPurge&quot;:&quot;NO&quot;,&quot;enabled&quot;:&quot;YES&quot;,&quot;fixed&quot;:&quot;YES&quot;,&quot;origin&quot;:&quot;MANUAL_LOAD_FROM_AWR&quot;,&quot;reproduced&quot;:&quot;YES&quot;,&quot;timeLastExecuted&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;timeLastModified&quot;:&quot;\u003cdateTime\u003e&quot;}]}