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

home |  up