Get all sampled session activity in the database

get

/database/performance/active_sessions_history/

Oracle Diagnostics Pack licence is required for this service. Returns all records from GV$ACTIVE_SESSION_HISTORY. A client requires SQL Administrator role to invoke this service.

Request

Supported Media Types
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 sampled session activity in the database.
Body ()
Root Schema : PerformanceActionSessionHistories
Type: object
Show Source
Nested Schema : items
Type: array
Show Source
  • PerformanceActionSessionHistoriesItem
    This object represents a sampled session activity in the database from GV$ACTIVE_SESSION_HISTORY. It contains snapshots of active database sessions taken once a second. A database session is considered active if it was on the CPU or was waiting for an event that didn't belong to the Idle wait class. The list of attributes may vary depending on database version.
Nested Schema : PerformanceActionSessionHistoriesItem
Type: object
This object represents a sampled session activity in the database from GV$ACTIVE_SESSION_HISTORY. It contains snapshots of active database sessions taken once a second. A database session is considered active if it was on the CPU or was waiting for an event that didn't belong to the Idle wait class. The list of attributes may vary depending on database version.
Show Source
Nested Schema : LinkRelation
Type: object
Show Source
Back to Top