REST APIs for Oracle Database

Monitoring REST Endpoints

Monitoring

The operations from the Monitoring category.

Get a session: Method: get
Path: /database/monitoring/sessions/{sid},{serial_number}/
Get a session locks that is blocking other sessions: Method: get
Path: /database/monitoring/session_locks/holding/{session_id},{lock_id1},{lock_id2}
Get a specific lock that a session is waiting on: Method: get
Path: /database/monitoring/session_locks/waiting/{session_id},{lock_id1},{lock_id2}
Get a specific session lock record: Method: get
Path: /database/monitoring/session_locks/{session_id},{lock_id1},{lock_id2}
Get a specific session wait: Method: get
Path: /database/monitoring/session_waits/{sid},{seq_number}
Get a specific session wait class record: Method: get
Path: /database/monitoring/session_wait_classes/{sid},{serial_number},{wait_class_number}
Get all alerts: Method: get
Path: /database/monitoring/alerts/
Get all current sessions: Method: get
Path: /database/monitoring/sessions/
Get all locks held in the database: Method: get
Path: /database/monitoring/session_locks/
Get all locks that are blocking other sessions: Method: get
Path: /database/monitoring/session_locks/holding/
Get all locks that sessions are waiting on: Method: get
Path: /database/monitoring/session_locks/waiting/
Get all long running operations for a Session: Method: get
Path: /database/monitoring/sessions/{sid},{serial_number}/long_running_operations
Get all session limits: Method: get
Path: /database/monitoring/session_limits
Get all session wait class records: Method: get
Path: /database/monitoring/session_wait_classes/
Get all session waits: Method: get
Path: /database/monitoring/session_waits/
Get all wait class metrics: Method: get
Path: /database/monitoring/wait_class_metrics
Get an alert record: Method: get
Path: /database/monitoring/alerts/{record_id}
Get count of alerts by message level: Method: get
Path: /database/monitoring/alerts_summaries/by_message_level
Get count of alerts by message type: Method: get
Path: /database/monitoring/alerts_summaries/by_message_type
Get count of different session types: Method: get
Path: /database/monitoring/session_summaries/by_type
Get count of recent alerts by message level: Method: get
Path: /database/monitoring/alerts_recent_summaries/by_message_level
Get count of recent alerts by message type: Method: get
Path: /database/monitoring/alerts_recent_summaries/by_message_type
Get current active process for a session: Method: get
Path: /database/monitoring/sessions/{sid},{serial_number}/process
Get time totals for all registered wait classes: Method: get
Path: /database/monitoring/wait_class_totals
Get wait time summary from recent active session history records: Method: get
Path: /database/monitoring/waits_recent