Oracle: DBA_HIST_WR_CONTROL

select
   case when vdb.dbid = wrc.dbid then '*' end e,
   wrc.snap_interval,
   wrc.retention,
   wrc.topnsql,
   wrc.con_id,
   wrc.dbid,
   wrc.src_dbid,
   wrc.src_dbname
from
   v$database          vdb cross join
   dba_hist_wr_control wrc;