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.3.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 |
| 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 starts running |
Sample query
Query all threads of the current user tenant in all OBServer nodes for the tenant in a parallel execution scenario.
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