Oracle Partitioning Monitoring API

openapi: 3.2.0
info:
  description: '<p>Provides the Oracle REST Data Services (ORDS) users the ability to perform Oracle Database management and monitoring operations through a user-friendly REST API. Depending on the database version and configuration, ORDS database APIs provide services such as manage pluggable databases, export data, and review database performance.</p><p>To install and configure Oracle REST Data Services refer to the <a href=https://docs.oracle.com/pls/topic/lookup?ctx=ords-latest&id=ORDIG> Oracle&reg REST Data Services Installation and Configuration Guide</a>.</p>

    <p>An OpenAPI V3 document that describes the available ORDS database API services can be retrieved from a running ORDS instance. The API document can be imported into compatible development tools and invoked from there. The URL to retrieve the API document depends on the your configuration. <p><p>The pattern for the API document URL is: </p>

    <code>https://&lt;server&gt;/&lt;context root&gt;/&lt;my database&gt;/&lt;my schema&gt;/_/db-api/stable/&lt;service path&gt;  </code>

    <p>Where, the <code>&lt;my database&gt;</code> and  <code>&lt;my schema&gt;</code> variables can be optional, depending on the ORDS configuration and the service invoked.'
  version: 2026.03.26
  title: Oracle REST Data Services Monitoring API
  contact:
    name: Oracle REST Data Services
    url: https://www.oracle.com/database/technologies/appdev/rest.html
  x-summary: Provides the Oracle REST Data Services (ORDS) users the ability to perform Oracle Database management and monitoring operations through a user-friendly REST API.
tags:
- name: Monitoring
  description: Services related to monitoring the Oracle database instance.
paths:
  /database/monitoring/alerts/:
    get:
      tags:
      - Monitoring
      summary: Get all alerts
      description: Returns records from V$DIAG_ALERT_EXT. In an Oracle RAC environment, data returned by this service may vary according to the instance to which a session is connected. A client requires SQL Administrator role to invoke this service.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: Returns database alerts.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringAlerts'
      x-internal-id: database-monitoring-alerts--get
      x-filename-id: database-monitoring-alerts-get
  /database/monitoring/alerts/{record_id}:
    get:
      tags:
      - Monitoring
      summary: Get an alert record
      description: Returns specific alert record from V$DIAG_ALERT_EXT. In an Oracle RAC environment, data returned by this service may vary according to the instance to which a session is connected. A client requires SQL Administrator role to invoke this service.
      parameters:
      - name: record_id
        in: path
        description: Identifier for the alert record.
        required: true
        schema:
          type: number
      responses:
        '200':
          description: Information on a specific alert.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringAlertsItem'
      x-internal-id: database-monitoring-alerts-{record_id}-get
      x-filename-id: database-monitoring-alerts-record_id-get
  /database/monitoring/alerts_recent_summaries/by_message_level:
    get:
      tags:
      - Monitoring
      summary: Get count of recent alerts by message level
      description: Group by message level on V$DIAG_ALERT_EXT originating within the last 7 days. In an Oracle RAC environment, data returned by this service may vary according to the instance to which a session is connected. A client requires SQL Administrator role to invoke this service.
      responses:
        '200':
          description: Summary of alerts from the last 7 days, aggregated by message level.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringAlertsSummaryMessageLevelItem'
      x-internal-id: database-monitoring-alerts_recent_summaries-by_message_level-get
      x-filename-id: database-monitoring-alerts_recent_summaries-by_message_level-get
  /database/monitoring/alerts_recent_summaries/by_message_type:
    get:
      tags:
      - Monitoring
      summary: Get count of recent alerts by message type
      description: Group by message type on V$DIAG_ALERT_EXT originating within the last 7 days. In an Oracle RAC environment, data returned by this service may vary according to the instance to which a session is connected. A client requires SQL Administrator role to invoke this service.
      responses:
        '200':
          description: Summary of alerts from the last 7 days, aggregated by message type.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringAlertsSummaryMessageTypeItem'
      x-internal-id: database-monitoring-alerts_recent_summaries-by_message_type-get
      x-filename-id: database-monitoring-alerts_recent_summaries-by_message_type-get
  /database/monitoring/alerts_summaries/by_message_level:
    get:
      tags:
      - Monitoring
      summary: Get count of alerts by message level
      description: Group by message level on V$DIAG_ALERT_EXT. In an Oracle RAC environment, data returned by this service may vary according to the instance to which a session is connected. A client requires SQL Administrator role to invoke this service.
      responses:
        '200':
          description: Summary of alerts, broken down by message level.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringAlertsSummaryMessageLevelItem'
      x-internal-id: database-monitoring-alerts_summaries-by_message_level-get
      x-filename-id: database-monitoring-alerts_summaries-by_message_level-get
  /database/monitoring/alerts_summaries/by_message_type:
    get:
      tags:
      - Monitoring
      summary: Get count of alerts by message type
      description: Group by message type on V$DIAG_ALERT_EXT. In an Oracle RAC environment, data returned by this service may vary according to the instance to which a session is connected. A client requires SQL Administrator role to invoke this service.
      parameters: []
      responses:
        '200':
          description: Summary of alerts broken down by message type.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringAlertsSummaryMessageTypeItem'
      x-internal-id: database-monitoring-alerts_summaries-by_message_type-get
      x-filename-id: database-monitoring-alerts_summaries-by_message_type-get
  /database/monitoring/session_limits:
    get:
      tags:
      - Monitoring
      summary: Get all session limits
      description: Get all resource limits for sessions using GV$RESOURCE_LIMIT view. Since GV$RESOURCE_LIMIT exposes global level information, it can only be queried from CDB$ROOT or in a non-CDB database. A client requires SQL Administrator role to invoke this service.
      parameters: []
      responses:
        '200':
          description: All session limits in the database.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringSessionLimitsItem'
      x-internal-id: database-monitoring-session_limits-get
      x-filename-id: database-monitoring-session_limits-get
  /database/monitoring/session_locks/:
    get:
      tags:
      - Monitoring
      summary: Get all locks held in the database
      description: Get all locks that are held in the database using DBA_LOCK view. A client requires SQL Administrator role to invoke this service.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: All locks held in the database.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringSessionLocks'
      x-internal-id: database-monitoring-session_locks--get
      x-filename-id: database-monitoring-session_locks-get
  /database/monitoring/session_locks/{session_id},{lock_id1},{lock_id2}:
    get:
      tags:
      - Monitoring
      summary: Get a specific session lock record
      description: Returns the corresponding record from DBA_LOCK view. A client requires SQL Administrator role to invoke this service.
      parameters:
      - name: session_id
        in: path
        description: Session holding or acquiring the lock.
        required: true
        schema:
          type: number
      - name: lock_id1
        in: path
        description: Type-specific lock identifier, part 1.
        required: true
        schema:
          type: string
      - name: lock_id2
        in: path
        description: Type-specific lock identifier, part 2.
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Information on a specific lock.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringSessionLocksItem'
      x-internal-id: database-monitoring-session_locks-{session_id},{lock_id1},{lock_id2}-get
      x-filename-id: database-monitoring-session_locks-session_id-lock_id1-lock_id2-get
  /database/monitoring/session_locks/holding/:
    get:
      tags:
      - Monitoring
      summary: Get all locks that are blocking other sessions
      description: Using DBA_LOCKS and DBA_BLOCKERS views, this service returns a list of DBA_LOCKS records where the session is not waiting for a locked object but is holding a lock on an object for which another session is waiting. In an Oracle RAC environment, this only applies if the blocker is on the same instance. A client requires SQL Administrator role to invoke this service.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: All locks that are blocking other sessions.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringSessionLocksHolding'
      x-internal-id: database-monitoring-session_locks-holding--get
      x-filename-id: database-monitoring-session_locks-holding-get
  /database/monitoring/session_locks/holding/{session_id},{lock_id1},{lock_id2}:
    get:
      tags:
      - Monitoring
      summary: Get a session lock that is blocking other sessions
      description: Using DBA_LOCKS and DBA_BLOCKERS views, this service returns a specific DBA_LOCKS record where the session is not waiting for a locked object but is holding a lock on an object for which another session is waiting. In an Oracle RAC environment, this only applies if the blocker is on the same instance. A client requires SQL Administrator role to invoke this service.
      parameters:
      - name: session_id
        in: path
        description: Session identifier.
        required: true
        schema:
          type: number
      - name: lock_id1
        in: path
        description: Type-specific lock identifier, part 1.
        required: true
        schema:
          type: string
      - name: lock_id2
        in: path
        description: Type-specific lock identifier, part 2.
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Information on a specific session lock.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringSessionLocksItem'
      x-internal-id: database-monitoring-session_locks-holding-{session_id},{lock_id1},{lock_id2}-get
      x-filename-id: database-monitoring-session_locks-holding-session_id-lock_id1-lock_id2-get
  /database/monitoring/session_locks/waiting/:
    get:
      tags:
      - Monitoring
      summary: Get all locks that sessions are waiting on
      description: Using DBA_LOCKS and DBA_WAITERS views, this service returns a list of DBA_LOCKS records for sessions that are waiting on locks held by other sessions. In an Oracle RAC environment, this only applies if the waiter is on the same instance. A client requires SQL Administrator role to invoke this service.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: All locks in the database that sessions are waiting on.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringSessionLocksWaiting'
      x-internal-id: database-monitoring-session_locks-waiting--get
      x-filename-id: database-monitoring-session_locks-waiting-get
  /database/monitoring/session_locks/waiting/{session_id},{lock_id1},{lock_id2}:
    get:
      tags:
      - Monitoring
      summary: Get a specific lock that a session is waiting on
      description: Using DBA_LOCKS and DBA_WAITERS views, this service returns the corresponding DBA_LOCKS records for session that is waiting on locks held by other sessions. In an Oracle RAC environment, this only applies if the waiter is on the same instance. A client requires SQL Administrator role to invoke this service.
      parameters:
      - name: session_id
        in: path
        description: Session identifier.
        required: true
        schema:
          type: number
      - name: lock_id1
        in: path
        description: Type-specific lock identifier, part 1.
        required: true
        schema:
          type: string
      - name: lock_id2
        in: path
        description: Type-specific lock identifier, part 2.
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Information on a specific lock that a session is waiting on.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringSessionLocksItem'
      x-internal-id: database-monitoring-session_locks-waiting-{session_id},{lock_id1},{lock_id2}-get
      x-filename-id: database-monitoring-session_locks-waiting-session_id-lock_id1-lock_id2-get
  /database/monitoring/session_summaries/by_type:
    get:
      tags:
      - Monitoring
      summary: Get count of different session types
      description: Group by session type on GV$SESSION. A client requires SQL Administrator role to invoke this service.
      responses:
        '200':
          description: Summary of different session types in the database.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringSessionTypeSummariesItem'
      x-internal-id: database-monitoring-session_summaries-by_type-get
      x-filename-id: database-monitoring-session_summaries-by_type-get
  /database/monitoring/session_wait_classes/:
    get:
      tags:
      - Monitoring
      summary: Get all session wait class records
      description: Returns all records from GV$SESSION_WAIT_CLASS. A client requires SQL Administrator role to invoke this service.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: Summary of session wait classes in the database.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringSessionWaitClasses'
      x-internal-id: database-monitoring-session_wait_classes--get
      x-filename-id: database-monitoring-session_wait_classes-get
  /database/monitoring/session_wait_classes/{sid},{serial_number},{wait_class_number}:
    get:
      tags:
      - Monitoring
      summary: Get a specific session wait class record
      description: Returns the corresponding record from GV$SESSION_WAIT_CLASS. A client requires SQL Administrator role to invoke this service.
      parameters:
      - name: sid
        in: path
        description: Session identifier.
        required: true
        schema:
          type: number
      - name: serial_number
        in: path
        description: Session serial number.
        required: true
        schema:
          type: number
      - name: wait_class_number
        in: path
        description: Number of the wait class.
        required: true
        schema:
          type: number
      responses:
        '200':
          description: Information on the specified session wait class.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringSessionWaitClassesItem'
      x-internal-id: database-monitoring-session_wait_classes-{sid},{serial_number},{wait_class_number}-get
      x-filename-id: database-monitoring-session_wait_classes-sid-serial_number-wait_class_number-get
  /database/monitoring/session_waits/:
    get:
      tags:
      - Monitoring
      summary: Get all session waits
      description: Returns all records from GV$SESSION_WAIT.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: All session wait records from GV$SESSION_WAIT. A client requires SQL Administrator role to invoke this service.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringSessionWaits'
      x-internal-id: database-monitoring-session_waits--get
      x-filename-id: database-monitoring-session_waits-get
  /database/monitoring/session_waits/{sid},{seq_number}:
    get:
      tags:
      - Monitoring
      summary: Get a specific session wait
      description: Returns the corresponding record from GV$SESSION_WAIT. A client requires SQL Administrator role to invoke this service.
      parameters:
      - name: sid
        in: path
        description: Session identifier.
        required: true
        schema:
          type: number
      - name: seq_number
        in: path
        description: Wait sequence number.
        required: true
        schema:
          type: number
      responses:
        '200':
          description: Information on the specified session wait.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringSessionWaitsItem'
      x-internal-id: database-monitoring-session_waits-{sid},{seq_number}-get
      x-filename-id: database-monitoring-session_waits-sid-seq_number-get
  /database/monitoring/sessions/:
    get:
      tags:
      - Monitoring
      summary: Get all current sessions
      description: Returns all records on GV$SESSION. A client requires SQL Administrator role to invoke this service.
      parameters:
      - $ref: '#/components/parameters/Limit'
      - $ref: '#/components/parameters/Filter'
      responses:
        '200':
          description: All current sessions in the database.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringSessions'
      x-internal-id: database-monitoring-sessions--get
      x-filename-id: database-monitoring-sessions-get
  /database/monitoring/sessions/{sid},{serial_number}/:
    get:
      tags:
      - Monitoring
      summary: Get a session
      description: Returns the GV$SESSION for the specified Session Identifier and Session Serial Number. A client requires SQL Administrator role to invoke this service.
      parameters:
      - name: sid
        in: path
        description: Session identifier.
        required: true
        schema:
          type: number
      - name: serial_number
        in: path
        description: Session serial number.
        required: true
        schema:
          type: number
      responses:
        '200':
          description: Information on the specified session.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringSessionsItem'
      x-internal-id: database-monitoring-sessions-{sid},{serial_number}--get
      x-filename-id: database-monitoring-sessions-sid-serial_number-get
  /database/monitoring/sessions/{sid},{serial_number}/long_running_operations:
    get:
      tags:
      - Monitoring
      summary: Get all long running operations for a session
      description: Returns all records from GV$SESSION_LONGOPS for a specific session. A client requires SQL Administrator role to invoke this service.
      parameters:
      - name: sid
        in: path
        description: Session identifier.
        required: true
        schema:
          type: number
      - name: serial_number
        in: path
        description: Session serial number.
        required: true
        schema:
          type: number
      responses:
        '200':
          description: Information on long running operations for the session.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringSessionsLongRunningOperationItem'
      x-internal-id: database-monitoring-sessions-{sid},{serial_number}-long_running_operations-get
      x-filename-id: database-monitoring-sessions-sid-serial_number-long_running_operations-get
  /database/monitoring/sessions/{sid},{serial_number}/process:
    get:
      tags:
      - Monitoring
      summary: Get current active process for a session
      description: Returns all records from GV$PROCESS for a specific session. A client requires SQL Administrator role to invoke this service.
      parameters:
      - name: sid
        in: path
        description: Session identifier.
        required: true
        schema:
          type: number
      - name: serial_number
        in: path
        description: Session serial number.
        required: true
        schema:
          type: number
      responses:
        '200':
          description: Description of actives processes for a session.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringSessionsProcessItem'
      x-internal-id: database-monitoring-sessions-{sid},{serial_number}-process-get
      x-filename-id: database-monitoring-sessions-sid-serial_number-process-get
  /database/monitoring/wait_class_totals:
    get:
      tags:
      - Monitoring
      summary: Get time totals for all registered wait classes
      description: Returns all the records from GV$SYSTEM_WAIT_CLASS, except 'Idle' wait class. A client requires SQL Administrator role to invoke this service.
      parameters: []
      responses:
        '200':
          description: Summary information on the wait class time totals.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringWaitClassTotalsItem'
      x-internal-id: database-monitoring-wait_class_totals-get
      x-filename-id: database-monitoring-wait_class_totals-get
  /database/monitoring/waits_recent:
    get:
      tags:
      - Monitoring
      summary: Get wait time summary from recent active session history records
      description: Oracle Diagnostics Pack licence is required for this service. Group by sample_time and wait_class on GV$ACTIVE_SESSION_HISTORY for records with sample_time within the last 7 days. Note that time waited is in microseconds. A client requires SQL Administrator role to invoke this service.
      parameters: []
      responses:
        '200':
          description: Wait time summary from active session history records within the last 7 days.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringWaitsRecentItem'
      x-internal-id: database-monitoring-waits_recent-get
      x-filename-id: database-monitoring-waits_recent-get
  /database/monitoring/wait_class_metrics:
    get:
      tags:
      - Monitoring
      summary: Get all wait class metrics
      description: Returns all records from GV$WAITCLASSMETRIC for all GV$SYSTEM_WAIT_CLASS records except 'Idle' wait class. A client requires SQL Administrator role to invoke this service.
      parameters: []
      responses:
        '200':
          description: Wait class metrics records.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/MonitoringWaitClassMetricsItem'
      x-internal-id: database-monitoring-wait_class_metrics-get
      x-filename-id: database-monitoring-wait_class_metrics-get
components:
  schemas:
    MonitoringAlerts:
      type: object
      properties:
        items:
          type: array
          items:
            $ref: '#/components/schemas/MonitoringAlertsItem'
        hasMore:
          type: boolean
          description: Indicates if there are more records to be retrieved.
        limit:
          type: integer
          description: The actual page size limit on number of records applied by the server.
        offset:
          type: integer
          description: The actual index from which the item resources are returned.
        count:
          type: integer
          description: Total number of records in the current response.
        links:
          type: array
          items:
            $ref: '#/components/schemas/LinkRelation'
    MonitoringSessionLocksItem:
      type: object
      description: This object is represents a record on DBA_LOCK view. DBA_LOCK lists all locks or latches held in the database, and all outstanding requests for a lock or latch. The list of attributes may vary depending on database version.
      properties:
        session_id:
          type: integer
          description: Session holding or acquiring the lock.
        lock_type:
          type: string
          description: Lock type.
        mode_held:
          type: string
          description: Lock mode.
        mode_requested:
          type: string
          description: Lock mode requested.
        lock_id1:
          type: string
          description: Type-specific lock identifier, part 1.
        lock_id2:
          type: string
          description: Type-specific lock identifier, part 2.
        last_convert:
          type: integer
          description: The last convert.
        blocking_others:
          type: string
          description: Whether the lock is currently blocking others.
        con_id:
          type: integer
          description: The ID of the container to which the data pertains.
        links:
          type: array
          items:
            $ref: '#/components/schemas/LinkRelation'
    MonitoringWaitsRecentItem:
      type: object
      description: A summary of time waited for each wait class in GV$ACTIVE_SESSION_HISTORY.
      properties:
        items:
          type: array
          items:
            type: object
            properties:
              sample_time:
                type: string
                description: Time at which the sample was taken.
              wait_class:
                type: string
                description: Wait class name of the event for which the session was waiting at the time of sampling.
              time_waited:
                type: integer
                description: Amount of time (in microseconds) spent in waits from this wait class at the time of sampling.
        links:
          type: array
          items:
            $ref: '#/components/schemas/LinkRelation'
    MonitoringSessionWaitClassesItem:
      type: object
      description: This object represents a record from GV$SESSION_WAIT_CLASS view. GV$SESSION_WAIT_CLASS displays the time spent in various wait event operations on a per-session basis. The list of attributes may vary depending on database version.
      properties:
        inst_id:
          type: integer
          description: Oracle Real Application Clusters instance number for which this data relates to. In a non-RAC database this number will be 1.
        sid:
          type: integer
          description: Session identifier.
        serial#:
          type: integer
          description: Serial number.
        wait_class_id:
          type: integer
          description: Identifier of the wait class.
        wait_class#:
          type: integer
          description: Number of the wait class.
        wait_class:
          type: string
          description: Name of the wait class.
        total_waits:
          type: integer
          description: Number of times waits of the class occurred for the session.
        time_waited:
          type: integer
          description: Amount of time spent in the wait class by the session.
        con_id:
          type: integer
          description: The ID of the container to which the data pertains.
        links:
          type: array
          items:
            $ref: '#/components/schemas/LinkRelation'
    MonitoringWaitClassTotalsItem:
      type: object
      description: Time totals for each registered wait class
      properties:
        inst_id:
          type: integer
          description: Oracle Real Application Clusters instance number for which this data relates to. In a non-RAC database this number will be 1.
        wait_class_id:
          type: integer
          description: Identifier of the wait class.
        wait_class#:
          type: integer
          description: Number of the wait class.
        wait_class:
          type: string
          description: Name of the wait class.
        total_waits:
          type: integer
          description: Number of times waits of the class occurred.
        time_waited:
          type: integer
          description: Amount of time (in hundredths of a second) spent in the wait by all sessions in the instance.
        total_waits_fg:
          type: integer
          description: Number of times waits from this wait class occurred in foreground sessions.
        time_waited_fg:
          type: integer
          description: Amount of time (in hundredths of a second) spent in waits from this wait class in foreground sessions.
        con_id:
          type: integer
          description: The ID of the container to which the data pertains.
        links:
          type: array
          items:
            $ref: '#/components/schemas/LinkRelation'
    MonitoringSessionLocksHolding:
      type: object
      description: This collection represents database locks held by sessions that are blocking other sessions. The list of attributes may vary depending on database version.
      properties:
        items:
          type: array
          items:
            $ref: '#/components/schemas/MonitoringSessionLocksItem'
        hasMore:
          type: boolean
          description: Indicates if there are more records to be retrieved.
        limit:
          type: integer
          description: The actual page size limit on number of records applied by the server.
        offset:
          type: integer
          description: The actual index from which the item resources are returned.
        count:
          type: integer
          description: Total number of records in the current response.
        links:
          type: array
          items:
            $ref: '#/components/schemas/LinkRelation'
    MonitoringSessionLocks:
      type: object
      properties:
        items:
          type: array
          items:
            $ref: '#/components/schemas/MonitoringSessionLocksItem'
        hasMore:
          type: boolean
          description: Indicates if there are more records to be retrieved.
        limit:
          type: integer
          description: The actual page size limit on number of records applied by the server.
        offset:
          type: integer
          description: The actual index from which the item resources are returned.
        count:
          type: integer
          description: Total number of records in the current response.
        links:
          type: array
          items:
            $ref: '#/components/schemas/LinkRelation'
    MonitoringAlertsSummaryMessageLevelItem:
      type: object
      description: This object represents a summary of V$DIAG_ALERT_EXT records by message level. The list of attributes may vary depending on database version.
      properti

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