Lists the SQL statements from shared SQL area, also called the cursor cache.

GET {{baseUrl}}/managedDatabases/:managedDatabaseId/cursorCacheStatements?sqlText=<string>&page=<string>&limit=10&sortBy=sqlId&sortOrder=ASC

Lists the SQL statements from shared SQL area, also called the cursor cache.

Request Params

KeyDatatypeRequiredDescription
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.
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 statement summary data.
sortOrderstringThe option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Ascending order is the default order.

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;sqlId&quot;:&quot;\u003cstring\u003e&quot;,&quot;schema&quot;:&quot;\u003cstring\u003e&quot;,&quot;sqlText&quot;:&quot;\u003cstring\u003e&quot;},{&quot;sqlId&quot;:&quot;\u003cstring\u003e&quot;,&quot;schema&quot;:&quot;\u003cstring\u003e&quot;,&quot;sqlText&quot;:&quot;\u003cstring\u003e&quot;}]}