select HS_SESSION_ID, -- HS_SESSION_ID NUMBER PARAMETER, -- PARAMETER VARCHAR2(30) VALUE, -- VALUE VARCHAR2(64) SOURCE, -- SOURCE VARCHAR2(1) ENV -- ENV VARCHAR2(1) from GV$HS_PARAMETER WHERE INST_ID = userenv('instance')