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