Get SQL statistics for a specific session
get
/database/performance/active_sessions_history_waits/{sid},{seq_number}/active_sql
Return records from GV$SQLAREA for a given session with current waits on GV$SESSION_WAIT_HISTORY.
Request
Supported Media Types
- application/json
Path Parameters
-
seq_number: number
Sequence number of wait event; 1 is the most recent.
-
sid: number
Session Identifier.
Response
Supported Media Types
- application/json
200 Response
Stastics on the SQL statements currently executing for specific session.