# Oracle Partitioning Performance API

**Canonical:** https://apis.io/apis/oracle-partitioning/oracle-partitioning-performance-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 Performance 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 Performance. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, and an API reference.

Services related to the runtime performance of the Oracle database instance.

## Operations (15)

| Method | Path | Summary |
|---|---|---|
| GET | `/database/performance/active_sessions_history/` | Get all sampled session activity in the database |
| GET | `/database/performance/active_sessions_history/{sample_id},{session_id}` | Get a specified sampled session activity in the database |
| GET | `/database/performance/active_sessions_history_waits/` | Get the last 10 wait events for each active session |
| GET | `/database/performance/active_sessions_history_waits/{sid},{seq_number}/` | Get the specified wait event for specific active session |
| GET | `/database/performance/active_sessions_history_waits/{sid},{seq_number}/active_sql` | Get SQL statistics for a specific session |
| GET | `/database/performance/sql_statements/` | Get statistics for all SQL statements |
| GET | `/database/performance/sql_statements/{sql_id}/` | Get statistics for a SQL statement |
| GET | `/database/performance/sql_statements/{sql_id}/monitor/` | Get monitoring statistics for a SQL Statement |
| GET | `/database/performance/sql_statements/{sql_id}/monitor/{sql_exec_id},{sql_exec_start}/` | Get information on a monitored statement |
| GET | `/database/performance/sql_statements/{sql_id}/monitor/{sql_exec_id},{sql_exec_start}/parallelism` | Get parallel execution information for specific statement execution |
| GET | `/database/performance/sql_statements/{sql_id}/plan` | Get execution plan for an SQL Statement |
| GET | `/database/performance/sql_statements/{sql_id}/history` | Get historical statistics for a SQL statement |
| GET | `/database/performance/sql_statements/{sql_id}/text` | Get SQL statement |
| GET | `/database/performance/top_sql_statements/` | Get all SQL statements ordered by CPU time descending |
| GET | `/database/performance/top_sql_statements/maximums` | Get SQL statistics maximum values |

## Machine-readable artifacts (5)

- **OpenAPI** — https://raw.githubusercontent.com/api-evangelist/oracle-partitioning/refs/heads/main/openapi/oracle-partitioning-performance-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 Monitoring API](https://apis.io/apis/oracle-partitioning/oracle-partitioning-monitoring-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/)

## Tags

Performance

---

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