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

Supported Media Types
Path Parameters
Back to Top

Response

Supported Media Types

200 Response

Returns information on a monitored statement. The structure of the data may vary depending on the database used.
Body ()
Root Schema : PerformanceSQLStatementMonitorParallelism
Type: object
Describes the parallel execution of an SQL Statement. Using GV$SQL_MONITOR view, the information includes the Parallel Coordinator and the instance(s) where it was executed.
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : LinkRelation
Type: object
Show Source
Back to Top