Oracle Database

Oracle Database General API

Core database instance status, version, and configuration services

GitHub OpenAPI

Operations 31

GET /database/status Oracle Database Get database status #
GET /database/version Oracle Database Get database version #
GET /database/components/ Oracle Database Get all database components #
GET /database/parameters/ Oracle Database Get all database parameters #
GET /database/parameters/{name} Oracle Database Get a specific database parameter #
GET /database/security/users/ Oracle Database Get all database users #
GET /database/storage/bytes Oracle Database Get storage usage in bytes #
GET /database/storage/tablespaces/ Oracle Database Get all tablespaces storage information #
GET /database/storage/tablespaces/{tablespace_name}/ Oracle Database Get tablespace details #
GET /database/storage/tablespaces/{tablespace_name}/datafiles/ Oracle Database Get tablespace datafiles #
GET /database/feature_usage/ Oracle Database Get feature usage statistics #
POST /database/sessionless-transactions/ Oracle Database Start a sessionless transaction #
PUT /database/sessionless-transactions/{sessionlessTransactionID} Oracle Database Commit a sessionless transaction #
DELETE /database/sessionless-transactions/{sessionlessTransactionID} Oracle Database Rollback a sessionless transaction #
GET /database/components/{comp_id} Get a database component #
GET /database/connections/ Get a description of all local listeners for this database #
GET /database/connections/{host_name},{port},{service_name} Get a description of a specific local listener for this database #
POST /database/datapump/jobs/ Create a data pump job #
GET /database/feature_usage/{dbid},{name} Get usage statistic for a feature #
GET /database/security/users/{username} Get a specific database user #
GET /database/storage/tablespaces/{tablespace_name}/datafiles_usage Get data file usage summary for a specific tablespace #
GET /database/storage/tablespaces/{tablespace_name}/datafiles/{file_id}/ Get tablespace data file #
GET /database/storage/tablespaces/{tablespace_name}/datafiles/{file_id}/usage Get tablespace data file usage #
GET /database/storage/tablespaces/{tablespace_name}/history Get tablespace space usage history #
GET /database/storage/tablespaces/{tablespace_name}/segments/ Get tablespace segments #
GET /database/storage/tablespaces/{tablespace_name}/segments/{segment_name} Get a tablespace segment #
GET /database/storage/tablespaces/{tablespace_name}/tempfiles_usage Get temporary file usage summary for a specific tablespace #
GET /database/storage/tablespaces/{tablespace_name}/tempfiles/ Get temporary files for a tablespace #
GET /database/storage/tablespaces/{tablespace_name}/tempfiles/{file_id}/ Get tablespace temporary file #
GET /database/storage/tablespaces/{tablespace_name}/tempfiles/{file_id}/usage Get tablespace temporary file usage #
GET /environment/homes/{homeName}/ Get specific database Oracle Home #

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-general-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-general-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-general-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Oracle Database General API
  x-refined-note:
  - x-refined-note differs across the merged source definitions and was not carried
  version: '1.0'
  description: 'Operations tagged General across 2 of this provider''s published API definitions: oracle-database-ords-openapi.yml, oracle-database-general-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 (72 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/openapi/oracle-database-general-api-openapi.yml