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
Key | Datatype | Required | Description |
---|---|---|---|
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. | |||
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 statement summary data. | |
sortOrder | string | The option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Ascending order is the default order. |
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":[{"sqlId":"\u003cstring\u003e","schema":"\u003cstring\u003e","sqlText":"\u003cstring\u003e"},{"sqlId":"\u003cstring\u003e","schema":"\u003cstring\u003e","sqlText":"\u003cstring\u003e"}]}