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 all OBServer nodes.
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 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 tenant on all OBServer nodes in parallel execution scenarios.
obclient [SYS]> SELECT * FROM SYS.GV$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