Oracle Database Monitoring API
Database session monitoring, locks, alerts, and wait metrics
Operations 25
GET
/database/monitoring/alerts_summaries/by_message_level
Oracle Database Get alert summaries by message level
#
GET
/database/monitoring/alerts_recent_summaries/by_message_level
Get count of recent alerts by message level
#
GET
/database/monitoring/alerts_recent_summaries/by_message_type
Get count of recent alerts by message type
#
GET
/database/monitoring/session_locks/{session_id},{lock_id1},{lock_id2}
Get a specific session lock record
#
GET
/database/monitoring/session_locks/holding/{session_id},{lock_id1},{lock_id2}
Get a session lock that is blocking other sessions
#
GET
/database/monitoring/session_locks/waiting/{session_id},{lock_id1},{lock_id2}
Get a specific lock that a session is waiting on
#
GET
/database/monitoring/session_wait_classes/{sid},{serial_number},{wait_class_number}
Get a specific session wait class record
#
GET
/database/monitoring/sessions/{sid},{serial_number}/long_running_operations
Get all long running operations for a session
#
GET
/database/monitoring/sessions/{sid},{serial_number}/process
Get current active process for a session
#
GET
/database/monitoring/waits_recent
Get wait time summary from recent active session history records
#
Documentation
Documentation
https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/latest/
Documentation
https://docs.oracle.com/iaas/Content/Database/home.htm
APIReference
https://docs.oracle.com/iaas/api/#/en/database/20160918/
Documentation
https://docs.oracle.com/en/database/oracle/simple-oracle-document-access/
Specifications
OpenAPI
https://artifacts.apis.io/oracle-database/openapi/oracle-database-monitoring-api-openapi.yml
Schemas & Data
JSONSchema
https://artifacts.apis.io/oracle-database/json-schema/oracle-database-table.json
JSONSchema
https://artifacts.apis.io/oracle-database/json-schema/oracle-database-pluggable-database.json
JSONSchema
https://artifacts.apis.io/oracle-database/json-schema/oracle-database-autonomous-database.json
JSONSchema
https://artifacts.apis.io/oracle-database/json-schema/oracle-database-document.json
JSONSchema
https://artifacts.apis.io/oracle-database/json-schema/oracle-database-collection.json
Other Resources
Swagger
https://example.oracle.com/ords/metadata-catalog/
JSONLD
https://artifacts.apis.io/oracle-database/json-ld/oracle-database-context.jsonld
SDKs
https://docs.oracle.com/iaas/Content/API/Concepts/sdks.htm
REST API
https://docs.oracle.com/en/database/oracle/simple-oracle-document-access/rest/
Java API
https://docs.oracle.com/en/database/oracle/simple-oracle-document-access/java/