Note
This view is available starting with V4.0.0.
Purpose
In parallel execution scenarios, this view displays the execution information of each thread for the current tenant on the current OBServer node.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SESSION_ID | NUMBER(38) | NO | For V4.2.x versions:
|
| TENANT_ID | NUMBER(38) | NO | The tenant ID. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server. |
| SVR_PORT | NUMBER(38) | NO | The port number of the server. |
| TRACE_ID | VARCHAR2(128) | NO | The trace ID of the SQL statement. |
| QC_ID | NUMBER(38) | NO | The qc_id in PX. |
| SQC_ID | NUMBER(38) | NO | The sqc_id in PX. |
| WORKER_ID | NUMBER(38) | NO | The thread ID. |
| DFO_ID | NUMBER(38) | NO | The dfo_id in PX. |
| START_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the thread started running. |
Sample query
In the user tenant, query the execution information of all threads for the current tenant on the current OBServer node in a parallel execution scenario.
obclient [SYS]> SELECT * FROM SYS.V$OB_PX_WORKER_STAT\G
The query result is as follows:
***************** 1. row *****************
SESSION_ID: 3221520410
TENANT_ID: 1004
SVR_IP: 192.xx.xx.xx
SVR_PORT: 19510
TRACE_ID: Y4Cxxxxxxxxxxxxxxxxxxxxxxxxxxxxx-0-0
QC_ID: 1
SQC_ID: 0
WORKER_ID: 0
DFO_ID: 0
START_TIME: 2023-04-23 17:29:15.372461
1 row in set