select group_number, -- GROUP_NUMBER NUMBER user_number, -- USER_NUMBER NUMBER compound_index, -- COMPOUND_INDEX NUMBER incarnation, -- INCARNATION NUMBER os_id, -- OS_ID VARCHAR2(128) os_name -- OS_NAME VARCHAR2(64) from gv$asm_user where inst_id = USERENV('Instance')