GV$PQ_SLAVE definition in Oracle Database 11.2
GV$PQ_SLAVE
select
inst_id, -- INST_ID NUMBER
kxfpdpnam, -- SLAVE_NAME VARCHAR2(4)
decode( -- STATUS VARCHAR2(4)
bitand(kxfpdpflg, 16), 0, 'BUSY', 'IDLE'),
kxfpdpses, -- SESSIONS NUMBER
floor(kxfpdpcit / 6000), -- IDLE_TIME_CUR NUMBER
floor(kxfpdpcbt / 6000), -- BUSY_TIME_CUR NUMBER
floor(kxfpdpcct / 100), -- CPU_SECS_CUR NUMBER
kxfpdpclsnt + kxfpdpcrsnt, -- MSGS_SENT_CUR NUMBER
kxfpdpclrcv + kxfpdpcrrcv, -- MSGS_RCVD_CUR NUMBER
floor((kxfpdptit + kxfpdpcit) / 6000), -- IDLE_TIME_TOTAL NUMBER
floor((kxfpdptbt + kxfpdpcbt) / 6000), -- BUSY_TIME_TOTAL NUMBER
floor((kxfpdptct + kxfpdpcct) / 100), -- CPU_SECS_TOTAL NUMBER
kxfpdptlsnt + kxfpdpclsnt + kxfpdptrsnt + kxfpdpcrsnt,-- MSGS_SENT_TOTAL NUMBER
kxfpdptlrcv + kxfpdpclrcv + kxfpdptrrcv + kxfpdpcrrcv -- MSGS_RCVD_TOTAL NUMBER
from
x$kxfpdp
where
bitand(kxfpdpflg, 8) != 0