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/sql_statements/ Oracle Database Get all SQL statements #
GET /database/performance/top_sql_statements/ Oracle Database Get top SQL by CPU usage #
GET /database/performance/sql_statements/{sql_id}/ Oracle Database Get SQL statement statistics #
GET /database/performance/sql_statements/{sql_id}/text Oracle Database Get SQL statement text #
GET /database/performance/sql_statements/{sql_id}/plan Oracle Database Get SQL execution plan #
GET /database/performance/sql_statements/{sql_id}/history Oracle Database Get SQL statement history #
GET /database/performance/active_sessions_history/ Oracle Database Get active sessions history #
GET /database/performance/active_sessions_history_waits/ Oracle Database Get active session history waits #
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/{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/{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/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: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:
  title: Oracle Database Performance API
  x-refined-note:
  - x-refined-note differs across the merged source definitions and was not carried
  version: '1.0'
  description: 'Operations tagged Performance across 2 of this provider''s published API definitions: oracle-database-ords-openapi.yml, oracle-database-performance-api-openapi.yml. Each path carries the servers of the definition it was published in.'
servers:
- url: https://{host}:{port}/ords
  description: ORDS Server
  variables:
    host:
      default: localhost
      description: ORDS server hostname
    port:
      default: '8443'
      description: ORDS server port
tags:


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