select
ID, -- ID NUMBER
TYPE, -- TYPE VARCHAR2(14)
NAME, -- NAME VARCHAR2(32)
VALUE -- VALUE VARCHAR2(513)
from
GV$HM_INFO
where
inst_id=USERENV('Instance')