Get historical statistics for a SQL statement

get

/database/performance/sql_statements/{sql_id}/history

Oracle Diagnostics Pack licence is required for this service. Returns DBA_HIST_SQLSTAT and DBA_HIST_SNAPSHOT records for a specified SQL_ID. A client requires SQL Administrator role to invoke this service.

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

Historical statiscs for the specified SQL statement.
Body ()
Root Schema : PerformanceSQLStatementHistoryItem
Type: object
This object represents historical information about SQL statistics. The structure is based on DBA_HIST_SQLSTAT. The list of attributes may vary depending on database version.
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : LinkRelation
Type: object
Show Source
Back to Top