DBA Data[Home] [Help]

VIEW: SYS.GV_$SQL_OPTIMIZER_ENV

Source

View Text - Preformatted

select "INST_ID","ADDRESS","HASH_VALUE","SQL_ID","CHILD_ADDRESS","CHILD_NUMBER","ID","NAME","ISDEFAULT","VALUE","CON_ID" from gv$sql_optimizer_env
View Text - HTML Formatted

SELECT "INST_ID"
, "ADDRESS"
, "HASH_VALUE"
, "SQL_ID"
, "CHILD_ADDRESS"
, "CHILD_NUMBER"
, "ID"
, "NAME"
, "ISDEFAULT"
, "VALUE"
, "CON_ID"
FROM GV$SQL_OPTIMIZER_ENV