GV$RSRC_PLAN

select
inst_id,                 -- INST_ID NUMBER
name_kgskpft             -- NAME VARCHAR2(32)
from
x$kgskpft
home |  up  |  mailbox