VIEW: SYS.GV_$SES_OPTIMIZER_ENV

Source

View Text - Preformatted

select "INST_ID","SID","ID","NAME","SQL_FEATURE","ISDEFAULT","VALUE","CON_ID" from gv$ses_optimizer_env

View Text - HTML Formatted

SELECT "INST_ID"
, "SID"
, "ID"
, "NAME"
, "SQL_FEATURE"
, "ISDEFAULT"
, "VALUE"
, "CON_ID"
FROM GV$SES_OPTIMIZER_ENV