select
  SLAVE_NAME,                              -- SLAVE_NAME VARCHAR2(4)
  STATUS,                                  -- STATUS VARCHAR2(4)
  SESSIONS,                                -- SESSIONS NUMBER
  IDLE_TIME_CUR,                           -- IDLE_TIME_CUR NUMBER
  BUSY_TIME_CUR,                           -- BUSY_TIME_CUR NUMBER
  CPU_SECS_CUR,                            -- CPU_SECS_CUR NUMBER
  MSGS_SENT_CUR,                           -- MSGS_SENT_CUR NUMBER
  MSGS_RCVD_CUR,                           -- MSGS_RCVD_CUR NUMBER
  IDLE_TIME_TOTAL,                         -- IDLE_TIME_TOTAL NUMBER
  BUSY_TIME_TOTAL,                         -- BUSY_TIME_TOTAL NUMBER
  CPU_SECS_TOTAL,                          -- CPU_SECS_TOTAL NUMBER
  MSGS_SENT_TOTAL,                         -- MSGS_SENT_TOTAL NUMBER
  MSGS_RCVD_TOTAL                          -- MSGS_RCVD_TOTAL NUMBER
from
  GV$PQ_SLAVE
where
  inst_id = USERENV('Instance')