Parameters

Optimizer Environment for Currently Logged in Users

-- Optimizer Environment for Currently Logged in Users
SELECT SES.USERNAME,
SES.SID,
SOE.NAME,
SOE.VALUE,
SOE.ISDEFAULT
FROM V$SESSION SES,
V$SES_OPTIMIZER_ENV SOE
WHERE SES.SID=SOE.SID
ORDER BY USERNAME,
SES.SID,
NAME;