Oracle Database

Oracle Database Performance API

SQL performance analysis, execution plans, and active session history

GitHub OpenAPI
Business capability
IT Operations Management BC-600.40

Operations 15

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 #

Documentation

📖
Documentation
https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/latest/
📖
Documentation
https://docs.oracle.com/iaas/Content/Database/home.htm
📖
APIReference
https://docs.oracle.com/iaas/api/#/en/database/20160918/
📖
Documentation
https://docs.oracle.com/en/database/oracle/simple-oracle-document-access/

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/openapi/oracle-database-performance-api-openapi.yml

Schemas & Data

📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/json-schema/oracle-database-table.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/json-schema/oracle-database-pluggable-database.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/json-schema/oracle-database-autonomous-database.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/json-schema/oracle-database-document.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/json-schema/oracle-database-collection.json

Other Resources

🔗
Swagger
https://example.oracle.com/ords/metadata-catalog/
🔗
JSONLD
https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/json-ld/oracle-database-context.jsonld
🔗
SDKs
https://docs.oracle.com/iaas/Content/API/Concepts/sdks.htm
🔗
REST API
https://docs.oracle.com/en/database/oracle/simple-oracle-document-access/rest/
🔗
Java API
https://docs.oracle.com/en/database/oracle/simple-oracle-document-access/java/

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-performance-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

oracle-database-performance-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  description: Provides the Oracle REST Data Services (ORDS) users the ability to perform Oracle Database management and monitoring operations through a user-friendly REST API.
  version: 2026.03.26
  title: Oracle REST Data Services Performance 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:


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