Oracle Database

Oracle Database Monitoring API

Database session monitoring, locks, alerts, and wait metrics

GitHub OpenAPI
Business capability
IT Operations Management BC-600.40

Operations 25

GET /database/monitoring/sessions/ Oracle Database Get all sessions #
GET /database/monitoring/sessions/{sid},{serial_number}/ Oracle Database Get a specific session #
GET /database/monitoring/session_locks/ Oracle Database Get all session locks #
GET /database/monitoring/session_locks/holding/ Oracle Database Get blocking locks #
GET /database/monitoring/session_locks/waiting/ Oracle Database Get waiting locks #
GET /database/monitoring/alerts/ Oracle Database Get all alerts #
GET /database/monitoring/alerts_summaries/by_message_level Oracle Database Get alert summaries by message level #
GET /database/monitoring/wait_class_metrics Oracle Database Get wait class metrics #
GET /database/monitoring/wait_class_totals Oracle Database Get wait class totals #
GET /database/monitoring/session_limits Oracle Database Get session limits #
GET /database/monitoring/alerts/{record_id} Get an alert record #
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/alerts_summaries/by_message_type Get count of 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_summaries/by_type Get count of different session types #
GET /database/monitoring/session_wait_classes/ Get all session wait class records #
GET /database/monitoring/session_wait_classes/{sid},{serial_number},{wait_class_number} Get a specific session wait class record #
GET /database/monitoring/session_waits/ Get all session waits #
GET /database/monitoring/session_waits/{sid},{seq_number} Get a specific session wait #
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://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/openapi/oracle-database-monitoring-api-openapi.yml

Schemas & Data

📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/json-schema/oracle-database-table.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/json-schema/oracle-database-pluggable-database.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/json-schema/oracle-database-autonomous-database.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/json-schema/oracle-database-document.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/json-schema/oracle-database-collection.json

Other Resources

🔗
Swagger
https://example.oracle.com/ords/metadata-catalog/
🔗
JSONLD
https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/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/

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/oracle-database-monitoring-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

oracle-database-monitoring-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Oracle Database Monitoring API
  x-refined-note:
  - x-refined-note differs across the merged source definitions and was not carried
  version: '1.0'
  description: 'Operations tagged Monitoring across 2 of this provider''s published API definitions: oracle-database-ords-openapi.yml, oracle-database-monitoring-api-openapi.yml. Each path carries the servers of the definition it was published in.'
servers:
- url: https://{host}:{port}/ords
  description: ORDS Server
  variables:
    host:
      default: localhost
      description: ORDS server hostname
    port:
      default: '8443'
      description: ORDS server port
tags:


# --- truncated at 32 KB (62 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/openapi/oracle-database-monitoring-api-openapi.yml