DBA Data[Home] [Help]

VIEW: SYS.INT$DBA_HIST_OPTIMIZER_ENV

Source

View Text - Preformatted

select dbid, optimizer_env_hash_value, optimizer_env,
       decode(con_dbid, 0, dbid, con_dbid),
       con_dbid_to_id(decode(con_dbid, 0, dbid, con_dbid)) con_id
from WRH$_OPTIMIZER_ENV
View Text - HTML Formatted

SELECT DBID
, OPTIMIZER_ENV_HASH_VALUE
, OPTIMIZER_ENV
, DECODE(CON_DBID
, 0
, DBID
, CON_DBID)
, CON_DBID_TO_ID(DECODE(CON_DBID
, 0
, DBID
, CON_DBID)) CON_ID FROM WRH$_OPTIMIZER_ENV