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
  • 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 the SQL statements in the database ordered to show the top SQL statements first.
Body ()
Root Schema : PerformanceTopSQLStatements
Type: object
Show Source
Nested Schema : items
Type: array
Show Source
  • SQLStatement
    Corresponding to a record on GV$SQL, this object describes an SQL Statement. The list of attributes may vary depending on database version.
Nested Schema : SQLStatement
Type: object
Corresponding to a record on GV$SQL, this object describes an SQL Statement. The list of attributes may vary depending on database version.
Show Source
Nested Schema : LinkRelation
Type: object
Show Source
Back to Top