Get all SQL statements ordered by CPU time descending
get
/database/performance/top_sql_statements/
Returns records from GV$SQL ordered by CPU time descending, SQL Text ascending. A client requires SQL Administrator role to invoke this service.
Request
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 the SQL statements in the database ordered to show the top SQL statements first.