Database Reference
In-Depth Information
This view helps in determining any workload imbalances and helps to determine if the distribution is skewed.
This would indicate that there is low cardinality or there are low numbers of distinct values.
SQL> DESC GV$PQ_TQSTAT
Name Null? Type
----------------------------------------- -------- -------------
DFO_NUMBER NUMBER
TQ_ID NUMBER
SERVER_TYPE VARCHAR2(40)
NUM_ROWS NUMBER
BYTES NUMBER
OPEN_TIME NUMBER
AVG_LATENCY NUMBER
WAITS NUMBER
TIMEOUTS NUMBER
PROCESS VARCHAR2(40)
INSTANCE NUMBER
BREAK ON dfo_number ON tq_id
SELECT inst_id,
dfo_number,
tq_id,
server_type,
process,
num_rows,
bytes
FROM gv$pq_tqstat
ORDER BY dfo_number DESC,
tq_id,
server_type DESC,
process
GV$PX_SESSION
This view shows data about query server sessions, groups, sets, and server numbers. It also displays real-time data
about the processes working on behalf of parallel execution. It contains information such as requested DOP and the
actual DOP granted to the operation:
SELECT qcsid,
sid,
inst_id "INST",
server_group "GROUP",
server_set "SET",
degree "DEGREE",
req_degree "REQ DEGREE"
FROM gv$px_session
ORDER BY qcsid,
qcinst_id,
server_group,
server_set;
 
Search WWH ::




Custom Search