Get monitoring statistics for an SQL Statement

get

/database/performance/sql_statements/{sql_id}/monitor/

Oracle Tuning Pack licence is required for this service. Returns all GV$SQL_MONITOR records for a specified SQL_ID. GV$SQL_MONITOR will contain statistics only for SQL statements whose execution have been (or are being) monitored by Oracle.

Request

Supported Media Types
Path Parameters
Query Parameters
  • The maximum number of records to return.
  • Filtering is the process of limiting a collection resource by using a per-request dynamic filter definition across multiple page resources, where each page contains a subset of items found in the complete collection. Filtering enables efficient traversal of large collections.
Back to Top

Response

Supported Media Types

200 Response

Description of all monitored SQL statements in the database.
Body ()
Root Schema : ItemsCollection
Type: object
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : ResourceItem
Type: object
Additional Properties Allowed: true
Show Source
Nested Schema : LinkRelation
Type: object
Show Source
Back to Top