Purpose
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.
Fields
| Field | 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 server. |
| svr_port | bigint(20) | NO | The port number of the server. |
| trace_id | varchar(128) | NO | The 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. |
