GV$PGASTAT definition in Oracle Database 11.2
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