Get monitoring statistics for a 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. A client requires SQL Administrator role to invoke this service.
Request
Path Parameters
-
sql_id:
SQL identifier.
Query Parameters
-
limit(optional):
The maximum number of records to return.
-
q(optional):
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.
Response
200 Response
Description of all monitored SQL statements in the database.