Overview
v$tenant_px_worker_stat displays the execution information of each PX worker thread in parallel execution.
Unlike gv$tenant_px_worker_stat, this view displays only the threads under the current tenant.
Field description
| Field name | Type | Nullable | Description |
|---|---|---|---|
| session_id | BIGINT(20) | No | The ID of the session. |
| tenant_id | BIGINT(20) | No | The ID of the tenant. |
| svr_ip | varchar(32) | No | The IP address of the OBServer. |
| svr_port | BIGINT(20) | No | The port number of the OBServer. |
| trace_id | varchar(128) | No | Trace ID |
| qc_id | BIGINT(20) | No | The query coordinator (QC) ID in parallel execution. |
| sqc_id | BIGINT(20) | No | The sub query coordinator (SQC) ID in parallel execution. |
| worker_id | BIGINT(20) | No | The ID of the thread. |
| dfo_id | BIGINT(20) | No | The data flow operator (DFO) ID in parallel execution. |
| start_time | TIMESTAMP(6) | No | The time when the thread started to run. |