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