select
QC_INSTANCE_GROUP, -- QC_INSTANCE_GROUP VARCHAR2(64)
WHY, -- WHY VARCHAR2(23)
INSTANCE_NUMBER -- INSTANCE_NUMBER NUMBER
from
GV$PX_INSTANCE_GROUP
where
inst_id = USERENV('Instance')