Oracle Partitioning Monitoring API is one of 25 APIs that Oracle Partitioning publishes on the APIs.io network, described by a machine-readable OpenAPI specification.
Tagged areas include Monitoring. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, and an API reference.
This API exposes
25 operations
across 25 paths,
and defines 23 schemas.
It is described by OpenAPI 3.2.0, at version 2026.03.26.
Requests are made against the base URL https://{server}/{context-root}/{database}/{schema}/_/db-api/stable.
25 operations25 paths23 schemas25 GET
Metadata
The identity and technical contract details declared by the specification.
Oracle Partitioning Monitoring API declares
3 security schemes
for authenticating requests.
It accepts HTTP basic authentication (BasicAuth).
It accepts HTTP bearer tokens (BearerAuth).
It supports OAuth 2.0 (OAuth2) using the implicit, authorizationCode and clientCredentials flows.
Paths & Operations 25
Across 25 paths, the API surfaces 25 operations — 25 GET. Each is listed below with its method, path, parameters, and response codes.
Monitoring 25
Services related to monitoring the Oracle database instance.
Get wait time summary from recent active session history records
→ 200
GET
/database/monitoring/wait_class_metrics
Get all wait class metrics
→ 200
Schemas 23
The contract defines 23 schemas that model the data the API accepts and returns. The most detailed are MonitoringSessionsItem (105 properties), MonitoringAlertsItem (36 properties), MonitoringSessionsLongRunningOperationItem (29 properties), MonitoringSessionsProcessItem (26 properties). Each schema is shown below with its type and property counts.
MonitoringAlerts
object
6 properties
MonitoringSessionLocksItem
object
This object is represents a record on DBALOCK view. DBALOCK lists all locks or latches held in the database, and all outstanding requests for a lock or latch.…
10 properties
MonitoringWaitsRecentItem
object
A summary of time waited for each wait class in GV$ACTIVESESSIONHISTORY.
2 properties
MonitoringSessionWaitClassesItem
object
This object represents a record from GV$SESSIONWAITCLASS view. GV$SESSIONWAITCLASS displays the time spent in various wait event operations on a per-session ba…
10 properties
MonitoringWaitClassTotalsItem
object
Time totals for each registered wait class
10 properties
MonitoringSessionLocksHolding
object
This collection represents database locks held by sessions that are blocking other sessions. The list of attributes may vary depending on database version.
6 properties
MonitoringSessionLocks
object
6 properties
MonitoringAlertsSummaryMessageLevelItem
object
This object represents a summary of V$DIAGALERTEXT records by message level. The list of attributes may vary depending on database version.
7 properties
LinkRelation
object
2 properties2 required
MonitoringSessionWaits
object
6 properties
MonitoringAlertsSummaryMessageTypeItem
object
This object represents a summary of V$DIAGALERTEXT records by message type. The list of attributes may vary depending on database version.
7 properties
MonitoringSessionWaitClasses
object
6 properties
MonitoringSessionsLongRunningOperationItem
object
This object represents operations for a specific session that run for longer than 6 seconds (in absolute time).
29 properties
Filter
object
See Oracle REST Data Services production documentation 'Filtering in Queries' section.
MonitoringSessionsProcessItem
object
This object represents information about the currently active processes for a specific session. Data is retrieved from GV$PROCESS view.
26 properties
MonitoringSessionLimitsItem
object
This object is used to monitor the consumption of session resources in the database. Since GV$RESOURCELIMIT exposes global/ CDB level information, it can only…
8 properties
MonitoringAlertsItem
object
This object represents an alert log record from V$DIAGALERTEXT. V$DIAGALERTEXT shows the contents of the XML-based alert log in the Automatic Diagnostic Reposi…
36 properties
MonitoringSessionWaitsItem
object
This object represents a record from GV$SESSIONWAIT view. GV$SESSIONWAIT displays the current or last wait for each session. The list of attributes may vary de…
24 properties
MonitoringSessions
object
6 properties
MonitoringSessionsItem
object
This object represents a record from GV$SESSION view. GV$SESSION displays session information for each current session. The list of attributes may vary dependi…
105 properties
MonitoringSessionLocksWaiting
object
This collection represents database locks held by sessions that are waiting on other sessions. The list of attributes may vary depending on database version.
6 properties
MonitoringWaitClassMetricsItem
object
This object combines data from GV$WAITCLASSMETRIC and GV$SYSTEMWAITCLASS views to represent metric values of wait classes for the most recent 60-second interva…
2 properties
MonitoringSessionTypeSummariesItem
object
Using data from GV$SESSION this object represents a summary of the number of sessions in different states aggregated across different session types (BACKGROUND…
2 properties
Specification
The full machine-readable OpenAPI contract behind this narrative.
Every API here is available over the API and to AI agents over MCP. APIs is not yet its own endpoint on the v1 API. Reach this content through network search and the tag graph, or the MCP server below.
Installs https://mcp.apievangelist.com/mcp in Claude, Cursor, VS Code and the rest — one button, every client.
MCP tools for apis
4 tools reach this content
search_api_evangelistSearch every content type across the network at once.
find_relatedThe shared-tag relevance graph — what else covers this.
get_tagEverything one tag labels, across all content types.
guide_topicPRO — a curated bundle for a topic: area, guidance, rules, papers, stories, services.
A second provider on the same verified email joins the account you already have.
Your account
ⓘWhere this information came from
This is an independent, third-party profile of Oracle Partitioning Monitoring API, published by
API Evangelist. We do not operate, host, resell, or
support these APIs, and we are not affiliated with or endorsed by the company unless stated above.
Everything here is built from publicly available information — the company's own site,
developer portal, documentation, public repositories, and the specifications it publishes for public use.
Nothing is obtained by breaching a system, defeating an access control, or using credentials.
The Kin Score and Agent Readiness rating are independently calculated assessments of a company's
public API artifacts, scored against a published rubric. They are not certifications,
endorsements, security assessments, or audits.
Corrections, re-scores, and removal are free — no partnership or purchase required, and
you do not need to justify the request. A removed company is recorded as unrated, never scored
zero for having asked. Acknowledgement within one business day; removal within two.
info@apievangelist.com
·
Read the full data-sourcing policy → On a security or compliance team? Put security in the subject line and
you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.
