Oracle REST Data Services API

Performance REST Endpoints

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}/