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')