[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