Parallel Query Tuning - Expert Oracle RAC Performance Diagnostics and Tuning - page 264

QCSID SID INST GROUP SET DEGREE REQ DEGREE
------ ---------- ---- -------- -------- -------- ----------
208 158 1 1 1 7 7
208 167 4 1 1 7 7
208 704 7 1 1 7 7
208 649 6 1 1 7 7
208 454 5 1 1 7 7
208 63 2 1 1 7 7
208 168 8 1 1 7 7
208 208 1
300 606 4 1 1 6 6
300 647 4 1 1 6 6
300 742 4 1 1 6 6
300 60 4 1 1 6 6
300 148 4 1 1 6 6
300 548 4 1 1 6 6
GV$PX_SESSTAT
This view is a join between the V$PX_SESSION and V$SESSTAT tables. All session statistics available to a normal session
are available for all sessions performed using parallel execution.
SELECT qcsid,
sid,
inst_id "INST",
server_group "GROUP",
server_set "SET",
NAME "STAT NAME",
VALUE
FROM gv$px_sesstat a,
v$statname b
WHERE a.statistic# = b.statistic#
AND NAME LIKE 'physical reads'
AND VALUE > 0
ORDER BY qcsid,
qcinst_id,
server_group,
server_set;
QCSID SID INST GROUP SET STAT NAME VALUE
------ ----- ---- -------- -------- --------------- -----------
208 208 1 physical reads 40
300 606 4 1 1 physical reads 636
300 548 4 1 1 physical reads 650
300 647 4 1 1 physical reads 595
300 742 4 1 1 physical reads 638
300 60 4 1 1 physical reads 632
300 148 4 1 1 physical reads 653
300 300 4 physical reads 7