Oracle REST Data Services API

All REST Endpoints

Data Dictionary

Services related to the tables and views that provide information about the database.

Get a database link: Method: get
Path: /database/db_links/{owner},{db_link}
Get a partition: Method: get
Path: /database/objects/partitions/{table_owner},{table_name},{partition_name}
Get a procedure that is defined in package: Method: get
Path: /database/objects/packages/procedures/{object_id},{subprogram_id}
Get a specific column: Method: get
Path: /database/objects/columns/{owner},{table_name},{column_name}
Get a specific foreign keys: Method: get
Path: /database/objects/foreign_keys/{owner},{constraint_name}
Get a specific function: Method: get
Path: /database/objects/functions/{object_id}
Get a specific index: Method: get
Path: /database/objects/indexes/{owner},{index_name}
Get a specific object: Method: get
Path: /database/objects/{owner},{object_name},{object_type}
Get a specific table: Method: get
Path: /database/objects/tables/{owner},{table_name}
Get a specific tablespace: Method: get
Path: /database/tablespaces/{tablespace_name}
Get a synonym: Method: get
Path: /database/objects/synonyms/{owner},{synonym_name}
Get all arguments for functions and procedures: Method: get
Path: /database/objects/arguments/
Get all database links: Method: get
Path: /database/db_links/
Get all database objects: Method: get
Path: /database/objects/
Get all foreign keys: Method: get
Path: /database/objects/foreign_keys/
Get all functions: Method: get
Path: /database/objects/functions/
Get all indexes: Method: get
Path: /database/objects/indexes/
Get all materialized view logs: Method: get
Path: /database/objects/materialized_view_logs/
Get all object types: Method: get
Path: /database/objects/types/
Get all partitions in the database: Method: get
Path: /database/objects/partitions/
Get all procedures defined in package: Method: get
Path: /database/objects/packages/procedures/
Get all synonyms in the database: Method: get
Path: /database/objects/synonyms/
Get all table columns: Method: get
Path: /database/objects/columns/
Get all tables: Method: get
Path: /database/objects/tables/
Get all tablespaces: Method: get
Path: /database/tablespaces/
Get an argument: Method: get
Path: /database/objects/arguments/{object_id},{subprogram_id},{argument_name}
Get an object type: Method: get
Path: /database/objects/types/{owner},{type_name}
Get information on a specific materialized view log: Method: get
Path: /database/objects/materialized_view_logs/{log_owner},{log_table}

Data Guard

Services related to Oracle Data Guard. The product must be installed in the Oracle database that ORDS is configured to use.

Add a configuration: Method: post
Path: /database/dataguard/configuration/
Add a database: Method: post
Path: /database/dataguard/databases/
Alter a configuration property: Method: put
Path: /database/dataguard/configuration/properties/{property}
Convert, enable, disable, or set the role of a database: Method: put
Path: /database/dataguard/databases/{database}
Delete the current database from the broker: Method: delete
Path: /database/dataguard/databases/{database}
Delete the Data Guard instance: Method: delete
Path: /database/dataguard/databases/{database}/instances/{instance}
Enable or disable a configuration: Method: put
Path: /database/dataguard/configuration/
Get a database Data Guard property: Method: get
Path: /database/dataguard/databases/{database}/properties/{property}
Get the current broker configuration: Method: get
Path: /database/dataguard/configuration/
Get the current broker configuration database: Method: get
Path: /database/dataguard/databases/{database}
Get the current broker configuration databases: Method: get
Path: /database/dataguard/databases/
Get the current broker configuration properties: Method: get
Path: /database/dataguard/configuration/properties/
Get the current broker database instances information: Method: get
Path: /database/dataguard/databases/{database}/instances/
Get the database Data Guard properties: Method: get
Path: /database/dataguard/databases/{database}/properties/
Get the specified broker configuration property: Method: get
Path: /database/dataguard/configuration/properties/{property}
Remove the configuration: Method: delete
Path: /database/dataguard/configuration/
Set the value of a database Data Guard property: Method: put
Path: /database/dataguard/databases/{database}/properties/{property}

Data Pump

Services related to Oracle Data Pump. Oracle Data Pump technology enables very high-speed movement of data and metadata from one database to another. Functionality may differ depending on the configuration and permissions the database user has.

Create an export data pump job: Method: post
Path: /database/datapump/export
Create an import data pump job: Method: post
Path: /database/datapump/import
Get a file for a specific data pump job: Method: get
Path: /database/datapump/jobs/{owner_name},{job_name}/{filename}
Get a specific data pump job: Method: get
Path: /database/datapump/jobs/{owner_name},{job_name}/
Get all data pump jobs: Method: get
Path: /database/datapump/jobs/

Data Tools

Services related to loading, manipulating and analyzing data.

Creates Cloud Storage Link: Method: post
Path: /data-tools/cloud-storage-links/
Creates credentials: Method: post
Path: /data-tools/credentials/
Creates data load jobs: Method: post
Path: /data-tools/data-loads/
Creates Live Table Feed: Method: post
Path: /data-tools/live-table-feeds/
Delete a Cloud Storage Link: Method: delete
Path: /data-tools/cloud-storage-links/{owner},{storage_link_name}
Delete a credential: Method: delete
Path: /data-tools/credentials/{owner},{credential_name}
Delete data load job: Method: delete
Path: /data-tools/data-loads/{owner},{data_load_job_id}
Delete Live Table Feed: Method: delete
Path: /data-tools/live-table-feeds/{owner},{feed_name}
Gets Cloud Storage Links: Method: get
Path: /data-tools/cloud-storage-links/
Gets credentials: Method: get
Path: /data-tools/credentials/
Gets data load jobs: Method: get
Path: /data-tools/data-loads/
Gets Live Table Feed notification key: Method: get
Path: /data-tools/live-table-feeds/{owner},{feed_name}/key
Gets Live Table Feeds: Method: get
Path: /data-tools/live-table-feeds/
Gets progress of data load job: Method: get
Path: /data-tools/data-loads/{owner},{data_load_job_id}/progress
Gets specific Cloud Storage Link: Method: get
Path: /data-tools/cloud-storage-links/{owner},{storage_link_name}
Gets specific credential: Method: get
Path: /data-tools/credentials/{owner},{credential_name}
Gets specific data load job: Method: get
Path: /data-tools/data-loads/{owner},{data_load_job_id}
Gets specific Live Table Feed: Method: get
Path: /data-tools/live-table-feeds/{owner},{feed_name}
Modify Live Table Feed: Method: put
Path: /data-tools/live-table-feeds/{owner},{feed_name}
Surveys input data: Method: post
Path: /data-tools/surveys/
Triggers data load for Live Table Feed: Method: post
Path: /data-tools/live-table-feeds/{owner},{feed_name}/load_new_data

Environment

Services related to the Oracle database installation. The implementation is only available for Unix based operating systems.

Create a new database in the default Oracle Home: Method: post
Path: /environment/databases/
Create a new database in the specified Oracle Home: Method: post
Path: /environment/homes/{homeName}/databases/
Create a new DBCA job in the default Oracle Home: Method: post
Path: /environment/dbca/jobs/
Create a new DBCA job in the Oracle Home: Method: post
Path: /environment/homes/{homeName}/dbca/jobs/
Delete the specified DBCA job in the default Oracle Home: Method: delete
Path: /environment/dbca/jobs/{jobId}/
Delete the specified DBCA job in the default Oracle Home: Method: delete
Path: /environment/homes/{homeName}/dbca/jobs/{jobId}/
Get a list of the databases defined in an Oracle Home: Method: get
Path: /environment/homes/{homeName}/databases/
Get a list of the databases defined in the default Oracle Home: Method: get
Path: /environment/databases/
Get a list of the DBCA database templates defined in an Oracle Home: Method: get
Path: /environment/homes/{homeName}/dbca/templates/
Get a list of the DBCA database templates defined in the default Oracle Home: Method: get
Path: /environment/dbca/templates/
Get a list of the DBCA jobs created through ORDS Database API in the default Oracle Home: Method: get
Path: /environment/dbca/jobs/
Get a list of the DBCA jobs created through ORDS Database API in the Oracle Home: Method: get
Path: /environment/homes/{homeName}/dbca/jobs/
Get a specific database defined in a specific Oracle Home: Method: get
Path: /environment/homes/{homeName}/databases/{databaseName}
Get a specific database defined in the default Oracle Home: Method: get
Path: /environment/databases/{databaseName}
Get a specific database template file in a specific Oracle Home: Method: get
Path: /environment/homes/{homeName}/dbca/templates/{filename}
Get a specific database template file in the default Oracle Home: Method: get
Path: /environment/dbca/templates/{filename}
Get a specified DBCA jobs created through ORDS Database API in the default Oracle Home: Method: get
Path: /environment/dbca/jobs/{jobId}/
Get a specified DBCA jobs created through ORDS Database API in the specified Oracle Home: Method: get
Path: /environment/homes/{homeName}/dbca/jobs/{jobId}/
Get database Oracle Homes: Method: get
Path: /environment/homes/
Get the DBCA log file content for a specified DBCA jobs created through ORDS Database API in the default Oracle Home: Method: get
Path: /environment/dbca/jobs/{jobId}/log
Get the DBCA log file content for a specified DBCA jobs created through ORDS Database API in the specified Oracle Home: Method: get
Path: /environment/homes/{homeName}/dbca/jobs/{jobId}/log

General

Services related to the Oracle database instance.

Create a data pump job: Method: post
Path: /database/datapump/jobs/
Get a database component: Method: get
Path: /database/components/{comp_id}
Get a description of a specific local listener for this database: Method: get
Path: /database/connections/{host_name},{port},{service_name}
Get a description of all local listeners for this database: Method: get
Path: /database/connections/
Get a specific database parameter: Method: get
Path: /database/parameters/{name}
Get a specific database user: Method: get
Path: /database/security/users/{username}
Get a tablespace segment: Method: get
Path: /database/storage/tablespaces/{tablespace_name}/segments/{segment_name}
Get all database components: Method: get
Path: /database/components/
Get all database parameters: Method: get
Path: /database/parameters/
Get all database users: Method: get
Path: /database/security/users/
Get all feature usage statistics: Method: get
Path: /database/feature_usage/
Get all tablespaces storage data: Method: get
Path: /database/storage/tablespaces/
Get data file usage summary for a specific tablespace: Method: get
Path: /database/storage/tablespaces/{tablespace_name}/datafiles_usage
Get data files for a tablespace: Method: get
Path: /database/storage/tablespaces/{tablespace_name}/datafiles/
Get database status: Method: get
Path: /database/status
Get database version: Method: get
Path: /database/version
Get specific database Oracle Home: Method: get
Path: /environment/homes/{homeName}/
Get storage for a specific tablespace: Method: get
Path: /database/storage/tablespaces/{tablespace_name}/
Get storage statistics: Method: get
Path: /database/storage/bytes
Get tablespace data file: Method: get
Path: /database/storage/tablespaces/{tablespace_name}/datafiles/{file_id}/
Get tablespace data file usage: Method: get
Path: /database/storage/tablespaces/{tablespace_name}/datafiles/{file_id}/usage
Get tablespace segments: Method: get
Path: /database/storage/tablespaces/{tablespace_name}/segments/
Get tablespace space usage history: Method: get
Path: /database/storage/tablespaces/{tablespace_name}/history
Get tablespace temporary file: Method: get
Path: /database/storage/tablespaces/{tablespace_name}/tempfiles/{file_id}/
Get tablespace temporary file usage: Method: get
Path: /database/storage/tablespaces/{tablespace_name}/tempfiles/{file_id}/usage
Get temporary file usage summary for a specific tablespace: Method: get
Path: /database/storage/tablespaces/{tablespace_name}/tempfiles_usage
Get temporary files for a tablespace: Method: get
Path: /database/storage/tablespaces/{tablespace_name}/tempfiles/
Get usage statistic for a feature: Method: get
Path: /database/feature_usage/{dbid},{name}

Monitoring

Services related to monitoring the Oracle database instance.

Get a session: Method: get
Path: /database/monitoring/sessions/{sid},{serial_number}/
Get a session lock that is blocking other sessions: Method: get
Path: /database/monitoring/session_locks/holding/{session_id},{lock_id1},{lock_id2}
Get a specific lock that a session is waiting on: Method: get
Path: /database/monitoring/session_locks/waiting/{session_id},{lock_id1},{lock_id2}
Get a specific session lock record: Method: get
Path: /database/monitoring/session_locks/{session_id},{lock_id1},{lock_id2}
Get a specific session wait: Method: get
Path: /database/monitoring/session_waits/{sid},{seq_number}
Get a specific session wait class record: Method: get
Path: /database/monitoring/session_wait_classes/{sid},{serial_number},{wait_class_number}
Get all alerts: Method: get
Path: /database/monitoring/alerts/
Get all current sessions: Method: get
Path: /database/monitoring/sessions/
Get all locks held in the database: Method: get
Path: /database/monitoring/session_locks/
Get all locks that are blocking other sessions: Method: get
Path: /database/monitoring/session_locks/holding/
Get all locks that sessions are waiting on: Method: get
Path: /database/monitoring/session_locks/waiting/
Get all long running operations for a session: Method: get
Path: /database/monitoring/sessions/{sid},{serial_number}/long_running_operations
Get all session limits: Method: get
Path: /database/monitoring/session_limits
Get all session wait class records: Method: get
Path: /database/monitoring/session_wait_classes/
Get all session waits: Method: get
Path: /database/monitoring/session_waits/
Get all wait class metrics: Method: get
Path: /database/monitoring/wait_class_metrics
Get an alert record: Method: get
Path: /database/monitoring/alerts/{record_id}
Get count of alerts by message level: Method: get
Path: /database/monitoring/alerts_summaries/by_message_level
Get count of alerts by message type: Method: get
Path: /database/monitoring/alerts_summaries/by_message_type
Get count of different session types: Method: get
Path: /database/monitoring/session_summaries/by_type
Get count of recent alerts by message level: Method: get
Path: /database/monitoring/alerts_recent_summaries/by_message_level
Get count of recent alerts by message type: Method: get
Path: /database/monitoring/alerts_recent_summaries/by_message_type
Get current active process for a session: Method: get
Path: /database/monitoring/sessions/{sid},{serial_number}/process
Get time totals for all registered wait classes: Method: get
Path: /database/monitoring/wait_class_totals
Get wait time summary from recent active session history records: Method: get
Path: /database/monitoring/waits_recent

ORDS REST Services

Custom Oracle REST Data Services built with SQL & PL/SQL.

Create a REST handler parameter: Method: post
Path: /ords/rest/parameters/
Create a REST module: Method: post
Path: /ords/rest/modules/
Create a REST module template: Method: post
Path: /ords/rest/templates/
Create a REST template handler: Method: post
Path: /ords/rest/handlers/
Create an ORDS OAuth client: Method: post
Path: /ords/rest/clients/
Create an ORDS privilege: Method: post
Path: /ords/rest/privileges/
Create an ORDS role: Method: post
Path: /ords/rest/roles/
Delete a REST handler parameter: Method: delete
Path: /ords/rest/parameters/{id}
Delete a REST module template: Method: delete
Path: /ords/rest/templates/{id}
Delete a REST template handler: Method: delete
Path: /ords/rest/handlers/{id}
Delete an ORDS OAuth client: Method: delete
Path: /ords/rest/clients/{id}
Delete an ORDS privilege: Method: delete
Path: /ords/rest/privileges/{id}
Delete an ORDS role: Method: delete
Path: /ords/rest/roles/{id}
Get a REST enabled object: Method: get
Path: /ords/rest/autorest/{id}
Get a REST enabled object metadata: Method: get
Path: /ords/rest/autorest/{id}/metadata
Get a REST handler parameter: Method: get
Path: /ords/rest/parameters/{id}
Get a REST handler source: Method: get
Path: /ords/rest/handlers/{id}/source
Get a REST module: Method: get
Path: /ords/rest/modules/{id}
Get a REST module source: Method: get
Path: /ords/rest/modules/{id}/source
Get a REST module template: Method: get
Path: /ords/rest/templates/{id}
Get a REST template handler: Method: get
Path: /ords/rest/handlers/{id}
Get all current schema recent REST objects: Method: get
Path: /ords/rest/overview/objects_recent
Get all ORDS OAuth clients: Method: get
Path: /ords/rest/clients/
Get all ORDS privileges: Method: get
Path: /ords/rest/privileges/
Get all ORDS privileges for a specific role: Method: get
Path: /ords/rest/roles/{id}/privileges/
Get all ORDS privileges in an OAuth client: Method: get
Path: /ords/rest/clients/{id}/privileges/
Get all ORDS properties values: Method: get
Path: /ords/properties/
Get all ORDS roles: Method: get
Path: /ords/rest/roles/
Get all ORDS roles in a privilege: Method: get
Path: /ords/rest/privileges/{id}/roles/
Get all ORDS roles in an OAuth client: Method: get
Path: /ords/rest/clients/{id}/roles/
Get all protected REST modules: Method: get
Path: /ords/rest/privilege/modules/
Get all REST enabled objects: Method: get
Path: /ords/rest/autorest/
Get all REST handler parameters: Method: get
Path: /ords/rest/parameters/
Get all REST module templates: Method: get
Path: /ords/rest/templates/
Get all REST modules: Method: get
Path: /ords/rest/modules/
Get all REST modules in a privilege: Method: get
Path: /ords/rest/privileges/{id}/modules/
Get all REST patterns in a privilege: Method: get
Path: /ords/rest/privileges/{id}/patterns/
Get all REST template handlers: Method: get
Path: /ords/rest/handlers/
Get an ORDS OAuth client: Method: get
Path: /ords/rest/clients/{id}
Get an ORDS privilege: Method: get
Path: /ords/rest/privileges/{id}
Get an ORDS property value: Method: get
Path: /ords/properties/{key}
Get an ORDS property value for a schema: Method: get
Path: /ords/properties/{schema}/{key}
Get an ORDS role: Method: get
Path: /ords/rest/roles/{id}
Get count of all the REST enabled objects: Method: get
Path: /ords/rest/autorest/summary
Get current ORDS schema and count of all current schema REST objects and count of all REST modules: Method: get
Path: /ords/rest/overview/
REST enable an object: Method: post
Path: /ords/rest/autorest/
Set an ORDS property value: Method: put
Path: /ords/properties/{key}
Set an ORDS property value for a schema: Method: put
Path: /ords/properties/{schema}/{key}
Unset an ORDS property value: Method: delete
Path: /ords/properties/{key}
Unset an ORDS property value for a schema: Method: delete
Path: /ords/properties/{schema}/{key}
Update a REST handler parameter: Method: put
Path: /ords/rest/parameters/{id}
Update a REST module: Method: put
Path: /ords/rest/modules/{id}
Update a REST module template: Method: put
Path: /ords/rest/templates/{id}
Update a REST template handler: Method: put
Path: /ords/rest/handlers/{id}
Update an ORDS OAuth client: Method: put
Path: /ords/rest/clients/{id}
Update an ORDS privilege: Method: put
Path: /ords/rest/privileges/{id}
Update an ORDS role: Method: put
Path: /ords/rest/roles/{id}
Update or disables a REST enabled object: Method: put
Path: /ords/rest/autorest/{id}
Updates the ORDS OAuth client avatar image.: Method: post
Path: /ords/rest/clients/{id}/logo/

Open Service Broker

Services related to the Open Service Broker compliant implementation that ORDS provides.

Deprovision a service instance: Method: delete
Path: /openservicebroker/v2/service_instances/{instance_id}
Get the catalog of services that the service broker offers: Method: get
Path: /openservicebroker/v2/catalog
Provision a service instance: Method: put
Path: /openservicebroker/v2/service_instances/{instance_id}

Oracle APEX

Services related to Oracle APEX. The product must be installed in the Oracle database that ORDS is configured to use.

Create or Update an APEX application, with a specific application id, in the specified workspace: Method: put
Path: /apex/workspaces/{workspace_name}/applications/{application_id}
Delete the specified APEX application: Method: delete
Path: /apex/workspaces/{workspace_name}/applications/{application_id}
Export APEX application components: Method: post
Path: /apex/applications/{application_id}
Get all applications in the specified workspace: Method: get
Path: /apex/workspaces/{workspace_name}/applications/
Get all workspaces: Method: get
Path: /apex/workspaces/
Get application statistics: Method: get
Path: /apex/statistics/application/{application_id}/
Get application statistics: Method: get
Path: /apex/statistics/workspace/{workspace_name}/
Get instance overview: Method: get
Path: /apex/statistics/overview
Get instance statistics: Method: get
Path: /apex/statistics/instance/
Get or export a specific APEX application: Method: get
Path: /apex/applications/{application_id}
Get workspace: Method: get
Path: /apex/workspaces/{workspace_name}/

Oracle Transactional Event Queues

Services related to Oracle Transactional Event Queues.

Create a Consumer Group: Method: post
Path: /database/txeventq/clusters/{cluster_id}/consumer-groups/{consumer_group_id}
Create a new Transactional Event Queue Topic: Method: post
Path: /database/txeventq/clusters/{cluster_id}/topics
Create Consumer Instance: Method: post
Path: /database/txeventq/consumers/{group_name}
Delete a Consumer Group: Method: delete
Path: /database/txeventq/clusters/{cluster_id}/consumer-groups/{consumer_group_id}
Delete Consumer Instance: Method: delete
Path: /database/txeventq/consumers/{group_name}/instances/{instance}
Delete the Transactional Event Queue Topic with the specified topic_name: Method: delete
Path: /database/txeventq/clusters/{cluster_id}/topics/{topic_name}
Describe the specified Transactional Event Queue Topic Partition: Method: get
Path: /database/txeventq/topics/{topic_name}/partitions/{partition_id}
Describe Transactional Event Queue Topic Partition specified in Cluster: Method: get
Path: /database/txeventq/clusters/{cluster_id}/topics/{topic_name}/partitions/{partition_id}
Describe Transactional Event Queue Topic Partitions: Method: get
Path: /database/txeventq/topics/{topic_name}/partitions
Describes Transactional Event Queue Topic in Cluster: Method: get
Path: /database/txeventq/clusters/{cluster_id}/topics/{topic_name}
Fetch messages for the specified Consumer: Method: get
Path: /database/txeventq/consumers/{group_name}/instances/{instance}/records
Get a Consumer Group: Method: get
Path: /database/txeventq/clusters/{cluster_id}/consumer-groups/{consumer_group_id}
Get all Transactional Event Queue Topics in the schema: Method: get
Path: /database/txeventq/topics
Get Consumer Groups in Cluster: Method: get
Path: /database/txeventq/clusters/{cluster_id}/consumer-groups
Get consumer lag for Transactional Event Queue Topic Partition: Method: get
Path: /database/txeventq/clusters/{cluster_id}/consumer-groups/{consumer_group_id}/lags/{topic_name}/partitions/{partition_id}
Get Consumer last Commit Offsets: Method: get
Path: /database/txeventq/consumers/{group_name}/instances/{instance}/offsets
Get description of a particular Transactional Event Queue Topic.: Method: get
Path: /database/txeventq/topics/{topic_name}
Get lag summary for Consumer Groups in Cluster: Method: get
Path: /database/txeventq/clusters/{cluster_id}/consumer-groups/{consumer_group_id}/lag-summary
Get Transactional Event Queue Topic Partition Offsets: Method: get
Path: /database/txeventq/topics/{topic_name}/partitions/{partition_id}/offsets
Lags/Offsets of consumers in the Consumer group: Method: get
Path: /database/txeventq/clusters/{cluster_id}/consumer-groups/{consumer_group_id}/lags
List Partitions for a Transactional Event Queue Topic in Cluster: Method: get
Path: /database/txeventq/clusters/{cluster_id}/topics/{topic_name}/partitions
List Transactional Event Queue Topics that belong to the specified database cluster: Method: get
Path: /database/txeventq/clusters/{cluster_id}/topics
Produce a message to the Transactional Event Queue Topic specified by topic_name: Method: post
Path: /database/txeventq/topics/{topic_name}
Produce messages in the specified Transactional Event Queue Topic Partition: Method: post
Path: /database/txeventq/topics/{topic_name}/partitions/{partition_id}
Seek to End of Partitions for Consumer Group: Method: post
Path: /database/txeventq/consumers/{group_name}/instances/{instance}/positions/end
Seek to specified Transactional Event Queue Topic partition offsets for Consumer Group: Method: post
Path: /database/txeventq/consumers/{group_name}/instances/{instance}/positions
Seek to start of Partitions for Consumer Group: Method: post
Path: /database/txeventq/consumers/{group_name}/instances/{instance}/positions/beginning
Subscribed list of Transactional Event Queue Topics: Method: get
Path: /database/txeventq/consumers/{group_name}/instances/{instance}/subscription

Performance

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

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

Pluggable Database Lifecycle Management

Services related to managing pluggable databases in an Oracle multitenant database instance.

Create a Pluggable Database: Method: post
Path: /database/pdbs/
Drop a PDB: Method: delete
Path: /database/pdbs/{pdb_name}
Get a pluggable database: Method: get
Path: /database/pdbs/{pdb_name}
Get all pluggable databases: Method: get
Path: /database/pdbs/
The list of all snapshots taken for the specified pluggable databases (PDBs): Method: get
Path: /database/pdb_snapshots/{pdb_name}/
The snapshots of all pluggable databases (PDBs) in the Container Database: Method: get
Path: /database/pdb_snapshots/
The specific snapshot taken of the specific pluggable databases (PDBs): Method: get
Path: /database/pdb_snapshots/{pdb_name}/{snapshot_name}
Update a specific PDB: Method: patch
Path: /database/pdbs/{pdb_name}

Pluggable Database Snapshot Carousel

Services related to managing pluggable databases snapshots in an Oracle database instance.

Configure automatic PDB snapshots.: Method: put
Path: /database/snapshots/
Create snapshot of the current pluggable databases, the name will be generated: Method: post
Path: /database/snapshots/
Create snapshot of the current pluggable databases, the name will be {snapshotName}: Method: post
Path: /database/snapshots/{snapshot_name}
Delete the specified snapshot: Method: delete
Path: /database/snapshots/{snapshot_name}
get all snapshots of the current pluggable databases: Method: get
Path: /database/snapshots/
Get snapshot mode in current PDB: Method: get
Path: /database/snapshot_mode
Get specific snapshot based on the name in current PDB: Method: get
Path: /database/snapshots/{snapshot_name}

RDF Graph

Services related to Oracle RDF Graph. Oracle RDF Graph provides functionality to manage knowledge graphs based on World Wide Web Consortium (W3C) standards such as RDF, OWL and SPARQL.

Append a graph: Method: post
Path: /database/rdf/networks/{network_owner},{network_name}/models/{model_name}/graph_store/1.1
Create entailment: Method: put
Path: /database/rdf/networks/{network_owner},{network_name}/entailments/{entailment_name}
Create RDF model: Method: put
Path: /database/rdf/networks/{network_owner},{network_name}/models/{model_name}
Create RDF network: Method: put
Path: /database/rdf/networks/{network_owner},{network_name}
Create virtual model: Method: put
Path: /database/rdf/networks/{network_owner},{network_name}/virtual_models/{virtual_model_name}
Delete a graph: Method: delete
Path: /database/rdf/networks/{network_owner},{network_name}/models/{model_name}/graph_store/1.1
Drop entailment: Method: delete
Path: /database/rdf/networks/{network_owner},{network_name}/entailments/{entailment_name}
Drop RDF model: Method: delete
Path: /database/rdf/networks/{network_owner},{network_name}/models/{model_name}
Drop RDF network: Method: delete
Path: /database/rdf/networks/{network_owner},{network_name}
Drop virtual model: Method: delete
Path: /database/rdf/networks/{network_owner},{network_name}/virtual_models/{virtual_model_name}
Entailment information: Method: get
Path: /database/rdf/networks/{network_owner},{network_name}/entailments/{entailment_name}
Execute a SPARQL query: Method: get
Path: /database/rdf/networks/{network_owner},{network_name}/models/{model_name}/sparql/1.1
Execute a SPARQL query or update: Method: post
Path: /database/rdf/networks/{network_owner},{network_name}/models/{model_name}/sparql/1.1
Get a graph: Method: get
Path: /database/rdf/networks/{network_owner},{network_name}/models/{model_name}/graph_store/1.1
List entailments: Method: get
Path: /database/rdf/networks/{network_owner},{network_name}/entailments/
List RDF models: Method: get
Path: /database/rdf/networks/{network_owner},{network_name}/models/
List RDF networks: Method: get
Path: /database/rdf/networks/
List virtual models: Method: get
Path: /database/rdf/networks/{network_owner},{network_name}/virtual_models/
RDF model information: Method: get
Path: /database/rdf/networks/{network_owner},{network_name}/models/{model_name}
RDF network information: Method: get
Path: /database/rdf/networks/{network_owner},{network_name}
Replace a graph: Method: put
Path: /database/rdf/networks/{network_owner},{network_name}/models/{model_name}/graph_store/1.1
Translate SPARQL to SQL: Method: get
Path: /database/rdf/networks/{network_owner},{network_name}/models/{model_name}/sparql2sql/1.1
Translate SPARQL to SQL: Method: post
Path: /database/rdf/networks/{network_owner},{network_name}/models/{model_name}/sparql2sql/1.1
Virtual model information: Method: get
Path: /database/rdf/networks/{network_owner},{network_name}/virtual_models/{virtual_model_name}

Scheduler

Oracle Scheduler, an enterprise job scheduler to help you simplify the scheduling of hundreds or even thousands of tasks. Oracle Scheduler (the Scheduler) is implemented by the procedures and functions in the DBMS_SCHEDULER PL/SQL package.

Get a specific Oracle Scheduler job: Method: get
Path: /database/scheduler/jobs/{owner},{job_name}
Get all Oracle Scheduler jobs: Method: get
Path: /database/scheduler/jobs/