# Oracle Partitioning Monitoring API

**Canonical:** https://apis.io/apis/oracle-partitioning/oracle-partitioning-monitoring-api/  
**Provider:** Oracle Partitioning — https://apis.io/providers/oracle-partitioning/  
**Base URL:** https://{server}/{context-root}/{database}/{schema}/_/db-api/stable  
**Documentation:** https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/

Oracle Partitioning Monitoring API is one of 25 APIs that [Oracle Partitioning](https://apis.io/providers/oracle-partitioning/) publishes on the [APIs.io](https://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.

Services related to monitoring the Oracle database instance.

## Operations (25)

| Method | Path | Summary |
|---|---|---|
| GET | `/database/monitoring/alerts/` | Get all alerts |
| 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_level` | Get count of alerts by message level |
| GET | `/database/monitoring/alerts_summaries/by_message_type` | Get count of alerts by message type |
| GET | `/database/monitoring/session_limits` | Get all session limits |
| GET | `/database/monitoring/session_locks/` | Get all locks held in the database |
| GET | `/database/monitoring/session_locks/{session_id},{lock_id1},{lock_id2}` | Get a specific session lock record |
| GET | `/database/monitoring/session_locks/holding/` | Get all locks that are blocking other sessions |
| 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/` | Get all locks that sessions are waiting on |
| 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/` | Get all current sessions |
| GET | `/database/monitoring/sessions/{sid},{serial_number}/` | Get a session |
| 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/wait_class_totals` | Get time totals for all registered wait classes |
| GET | `/database/monitoring/waits_recent` | Get wait time summary from recent active session history records |
| GET | `/database/monitoring/wait_class_metrics` | Get all wait class metrics |

## Machine-readable artifacts (5)

- **OpenAPI** — https://raw.githubusercontent.com/api-evangelist/oracle-partitioning/refs/heads/main/openapi/oracle-partitioning-monitoring-api-openapi.yml
- **Documentation** — https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/index.html
- **APIReference** — https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/26.1/orrst/rest-endpoints.html
- **ErrorCatalog** — https://raw.githubusercontent.com/api-evangelist/oracle-partitioning/refs/heads/main/errors/oracle-partitioning-problem-types.yml
- **DataModel** — https://raw.githubusercontent.com/api-evangelist/oracle-partitioning/refs/heads/main/data-model/oracle-partitioning-data-model.yml

## Other Oracle Partitioning APIs (12)

- [Oracle SQL Developer REST Services - Partitioning](https://apis.io/apis/oracle-partitioning/oracle-sql-developer-rest-services-partitioning/)
- [Oracle Cloud Infrastructure Database API - Partitioning](https://apis.io/apis/oracle-partitioning/oracle-cloud-infrastructure-database-api-partitioning/)
- [Oracle Partitioning Data Dictionary API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-data-dictionary-api/)
- [Oracle Partitioning Data Guard API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-data-guard-api/)
- [Oracle Partitioning Data Pump API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-data-pump-api/)
- [Oracle Partitioning Data Tools API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-data-tools-api/)
- [Oracle Partitioning Environment API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-environment-api/)
- [Oracle Partitioning General API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-general-api/)
- [Oracle Partitioning Open Service Broker API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-open-service-broker-api/)
- [Oracle Partitioning Oracle APEX API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-oracle-apex-api/)
- [Oracle Partitioning Oracle Transactional Event Queues API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-oracle-transactional-event-queues-api/)
- [Oracle Partitioning ORDS REST Services API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-ords-rest-services-api/)

## Tags

Monitoring

---

Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/apis/oracle-partitioning/oracle-partitioning-monitoring-api/). The API's provider profile, Kin Score and agent-readiness rating are at https://apis.io/providers/oracle-partitioning/.