select
  NAME,                                    -- NAME VARCHAR2(64)
  VALUE,                                   -- VALUE NUMBER
  UNIT                                     -- UNIT VARCHAR2(12)
from
  GV$PGASTAT
where
  INST_ID = USERENV('Instance')