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.
Request
Supported Media Types
- application/json
Query Parameters
-
limit(optional): integer(int32)
The maximum number of records to return.
-
q(optional): string
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
Supported Media Types
- application/json
200 Response
Description of the SQL statements in the database ordered to show the top SQL statements first.
Nested Schema : items
Type:
Show Source
array
-
Array of:
object ResourceItem
Additional Properties Allowed:
true