GV$PGASTAT

select
INST_ID,                 -- INST_ID NUMBER
QESMMSGANM,              -- NAME VARCHAR2(64)
decode                   -- VALUE NUMBER
  (QESMMSGAUN, 3, (QESMMSGAVL*QESMMSGAMU) /100, QESMMSGAVL*QESMMSGAMU),
decode                   -- UNIT VARCHAR2(12)
  (QESMMSGAUN, 0, 'bytes', 1, 'microseconds', 3, 'percent', '') 
from
X$QESMMSGA 
where
QESMMSGAVS = 1
home |  up  |  mailbox