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. A client requires SQL Administrator role to invoke this service.
Request
Path Parameters
-
seq_number:
Sequence number of wait event; 1 is the most recent.
-
sid:
Session Identifier.
Response
200 Response
Stastics on the SQL statements currently executing for specific session.