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