select
inst_id, -- INST_ID NUMBER
plan_id_kgskpft, -- ID NUMBER
name_kgskpft, -- NAME VARCHAR2(32)
decode( -- IS_TOP_PLAN VARCHAR2(5)
is_top_plan_kgskpft, 0, 'FALSE', 'TRUE'),
decode( -- CPU_MANAGED VARCHAR2(3)
cpu_rm_kgskpft, 0, 'OFF', 'ON')
from
x$kgskpft