select
inst_id, -- INST_ID NUMBER
id, -- ID NUMBER
decode( -- TYPE VARCHAR2(14)
type, 0, 'RUN', 1, 'RUN-RESUME', 2, 'FINDING', 3, 'RECOMMENDATION', 'UNKNOWN'),
name, -- NAME VARCHAR2(32)
value -- VALUE VARCHAR2(513)
from
x$dbkinfo