Get parallel execution information for specific statement execution
get
/database/performance/sql_statements/{sql_id}/monitor/{sql_exec_id},{sql_exec_start}/parallelism
Oracle Tuning Pack licence is required for this service. Returns information on a monitored statement that is executed in parallel. Using GV$SQL_MONITOR view, the information includes the Parallel Coordinator and the instance(s) where it was executed. A client requires SQL Administrator role to invoke this service.
Request
Path Parameters
-
sql_exec_id:
Execution identifier.
-
sql_exec_start:
Time when the execution started.
-
sql_id:
SQL identifier.
Response
200 Response
Returns information on a monitored statement. The structure of the data may vary depending on the database used.