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                    -- IDLE_TIME_CUR NUMBER
  (kxfpdpcit / 6000),
floor                    -- BUSY_TIME_CUR NUMBER
  (kxfpdpcbt / 6000),
floor (kxfpdpcct / 100), -- CPU_SECS_CUR NUMBER
kxfpdpclsnt              -- MSGS_SENT_CUR NUMBER
  + kxfpdpcrsnt,
kxfpdpclrcv              -- MSGS_RCVD_CUR NUMBER
  + kxfpdpcrrcv,
floor                    -- IDLE_TIME_TOTAL NUMBER
  ((kxfpdptit + kxfpdpcit) / 6000),
floor                    -- BUSY_TIME_TOTAL NUMBER
  ((kxfpdptbt + kxfpdpcbt) / 6000),
floor                    -- CPU_SECS_TOTAL NUMBER
  ((kxfpdptct + kxfpdpcct) / 100),
kxfpdptlsnt              -- MSGS_SENT_TOTAL NUMBER
  + kxfpdpclsnt + kxfpdptrsnt + kxfpdpcrsnt,
kxfpdptlrcv              -- MSGS_RCVD_TOTAL NUMBER
  + kxfpdpclrcv + kxfpdptrrcv + kxfpdpcrrcv 
from
x$kxfpdp 
where
bitand (kxfpdpflg, 8) != 0
home |  up  |  mailbox