Parameters
Submitted by dave on Thu, 02/25/2010 - 10:59
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;