Oracle Database

Oracle Database Monitoring API

Database session monitoring, locks, alerts, and wait metrics

Documentation GitHub OpenAPI

Operations 10

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 #

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

openapi: 3.2.0
info:
  title: Oracle Database Oracle REST Data Services (ORDS) Monitoring API
  description: RESTful API for Oracle Database management, monitoring, and data access through Oracle REST Data Services. Provides 300+ endpoints across 17 categories including database administration, performance monitoring, Data Guard management, Data Pump operations, pluggable database lifecycle, APEX management, RDF graph operations, and transactional event queues.
  version: 25.4.0
  contact:
    name: Oracle Support
    url: https://support.oracle.com
    email: support@oracle.com
  license:
    name: Oracle Technology Network License
    url: https://www.oracle.com/downloads/licenses/standard-license.html
  termsOfService: https://www.oracle.com/legal/terms.html
servers:
- url: https://{host}:{port}/ords
  description: ORDS Server
  variables:
    host:
      default: localhost
      description: ORDS server hostname
    port:
      default: '8443'
      description: ORDS server port
security:
- oauth2: []
- basicAuth: []
tags:
- name: Monitoring
  description: Database session monitoring, locks, alerts, and wait metrics
paths:
  /database/monitoring/sessions/:
    get:
      operationId: getSessions
      summary: Oracle Database Get all sessions
      description: Returns information about all active database sessions.
      tags:
      - Monitoring
      parameters:
      - $ref: '#/components/parameters/limitParam'
      - $ref: '#/components/parameters/offsetParam'
      responses:
        '200':
          description: Sessions retrieved successfully
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SessionList'
        '401':
          $ref: '#/components/responses/Unauthorized'
  /database/monitoring/sessions/{sid},{serial_number}/:
    get:
      operationId: getSession
      summary: Oracle Database Get a specific session
      description: Returns detailed information about a specific database session.
      tags:
      - Monitoring
      parameters:
      - name: sid
        in: path
        required: true
        schema:
          type: integer
      - name: serial_number
        in: path
        required: true
        schema:
          type: integer
      responses:
        '200':
          description: Session details retrieved successfully
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SessionDetail'
        '401':
          $ref: '#/components/responses/Unauthorized'
        '404':
          $ref: '#/components/responses/NotFound'
  /database/monitoring/session_locks/:
    get:
      operationId: getSessionLocks
      summary: Oracle Database Get all session locks
      description: Returns information about all current session locks.
      tags:
      - Monitoring
      responses:
        '200':
          description: Session locks retrieved successfully
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SessionLockList'
        '401':
          $ref: '#/components/responses/Unauthorized'
  /database/monitoring/session_locks/holding/:
    get:
      operationId: getBlockingLocks
      summary: Oracle Database Get blocking locks
      description: Returns information about sessions holding locks that block others.
      tags:
      - Monitoring
      responses:
        '200':
          description: Blocking locks retrieved successfully
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SessionLockList'
        '401':
          $ref: '#/components/responses/Unauthorized'
  /database/monitoring/session_locks/waiting/:
    get:
      operationId: getWaitingLocks
      summary: Oracle Database Get waiting locks
      description: Returns information about sessions waiting to acquire locks.
      tags:
      - Monitoring
      responses:
        '200':
          description: Waiting locks retrieved successfully
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SessionLockList'
        '401':
          $ref: '#/components/responses/Unauthorized'
  /database/monitoring/alerts/:
    get:
      operationId: getAlerts
      summary: Oracle Database Get all alerts
      description: Returns all database alerts and notifications.
      tags:
      - Monitoring
      responses:
        '200':
          description: Alerts retrieved successfully
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/AlertList'
        '401':
          $ref: '#/components/responses/Unauthorized'
  /database/monitoring/alerts_summaries/by_message_level:
    get:
      operationId: getAlertSummaries
      summary: Oracle Database Get alert summaries by message level
      description: Returns alert summary statistics grouped by message level.
      tags:
      - Monitoring
      responses:
        '200':
          description: Alert summaries retrieved successfully
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/AlertSummaryList'
        '401':
          $ref: '#/components/responses/Unauthorized'
  /database/monitoring/wait_class_metrics:
    get:
      operationId: getWaitClassMetrics
      summary: Oracle Database Get wait class metrics
      description: Returns database wait class performance metrics.
      tags:
      - Monitoring
      responses:
        '200':
          description: Wait class metrics retrieved successfully
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/WaitClassMetricList'
        '401':
          $ref: '#/components/responses/Unauthorized'
  /database/monitoring/wait_class_totals:
    get:
      operationId: getWaitClassTotals
      summary: Oracle Database Get wait class totals
      description: Returns total wait time statistics by wait class.
      tags:
      - Monitoring
      responses:
        '200':
          description: Wait class totals retrieved successfully
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/WaitClassTotalList'
        '401':
          $ref: '#/components/responses/Unauthorized'
  /database/monitoring/session_limits:
    get:
      operationId: getSessionLimits
      summary: Oracle Database Get session limits
      description: Returns the configured session limits and current usage.
      tags:
      - Monitoring
      responses:
        '200':
          description: Session limits retrieved successfully
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SessionLimitList'
        '401':
          $ref: '#/components/responses/Unauthorized'
components:
  schemas:
    Error:
      type: object
      properties:
        code:
          type: integer
        message:
          type: string
        type:
          type: string
    PaginatedResponse:
      type: object
      properties:
        items:
          type: array
          items: {}
        hasMore:
          type: boolean
        limit:
          type: integer
        offset:
          type: integer
        count:
          type: integer
        links:
          type: array
          items:
            $ref: '#/components/schemas/Link'
    SessionDetail:
      type: object
      properties:
        sid:
          type: integer
        serial_number:
          type: integer
        username:
          type: string
        status:
          type: string
        machine:
          type: string
        program:
          type: string
        sql_id:
          type: string
        event:
          type: string
        wait_class:
          type: string
        logon_time:
          type: string
          format: date-time
    SessionLockList:
      type: object
      properties:
        items:
          type: array
          items:
            type: object
            properties:
              sid:
                type: integer
              type:
                type: string
              mode_held:
                type: string
              mode_requested:
                type: string
              block:
                type: integer
    Link:
      type: object
      properties:
        rel:
          type: string
        href:
          type: string
          format: uri
    SessionList:
      allOf:
      - $ref: '#/components/schemas/PaginatedResponse'
      - type: object
        properties:
          items:
            type: array
            items:
              $ref: '#/components/schemas/SessionDetail'
    WaitClassTotalList:
      type: object
      properties:
        items:
          type: array
          items:
            type: object
            properties:
              wait_class:
                type: string
              total_waits:
                type: integer
                format: int64
              time_waited:
                type: number
    AlertSummaryList:
      type: object
      properties:
        items:
          type: array
          items:
            type: object
            properties:
              message_level:
                type: integer
              count:
                type: integer
    AlertList:
      type: object
      properties:
        items:
          type: array
          items:
            type: object
            properties:
              message_text:
                type: string
              message_level:
                type: integer
              originating_timestamp:
                type: string
                format: date-time
    WaitClassMetricList:
      type: object
      properties:
        items:
          type: array
          items:
            type: object
            properties:
              wait_class:
                type: string
              average_waiter_count:
                type: number
              dbtime_in_wait:
                type: number
    SessionLimitList:
      type: object
      properties:
        items:
          type: array
          items:
            type: object
            properties:
              resource_name:
                type: string
              current_utilization:
                type: integer
              max_utilization:
                type: integer
              limit_value:
                type: string
  parameters:
    limitParam:
      name: limit
      in: query
      description: Maximum number of items to return
      schema:
        type: integer
        minimum: 1
        default: 25
    offsetParam:
      name: offset
      in: query
      description: Number of items to skip before returning results
      schema:
        type: integer
        minimum: 0
        default: 0
  responses:
    NotFound:
      description: The specified resource was not found
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
    Unauthorized:
      description: Authentication required or credentials invalid
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
  securitySchemes:
    oauth2:
      type: oauth2
      flows:
        clientCredentials:
          tokenUrl: /ords/{schema}/oauth/token
          scopes: {}
        authorizationCode:
          authorizationUrl: /ords/{schema}/oauth/auth
          tokenUrl: /ords/{schema}/oauth/token
          scopes: {}
    basicAuth:
      type: http
      scheme: basic
externalDocs:
  description: ORDS REST API Documentation
  url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/25.4/orrst/

Oracle Database Monitoring API

Operations 10

Documentation

Specifications

Schemas & Data

Other Resources