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;