GV$RSRC_PLAN select inst_id, -- INST_ID NUMBER plan_id_kgskpft, -- ID NUMBER name_kgskpft, -- NAME VARCHAR2(32) is_top_plan_kgskpft -- IS_TOP_PLAN VARCHAR2(5) from x$kgskpft