VIEW: SYS.INT$DBA_HIST_LOG

Source

View Text - Preformatted

select log.snap_id, log.dbid, log.instance_number,
       group#, thread#, sequence#, bytes, members,
       archived, log.status, first_change#, first_time,
       decode(log.con_dbid, 0, log.dbid, log.con_dbid),
       0 con_id
  from DBA_HIST_SNAPSHOT sn, WRH$_LOG log
  where     sn.snap_id         = log.snap_id
        and sn.dbid            = log.dbid
        and sn.instance_number = log.instance_number

View Text - HTML Formatted

SELECT LOG.SNAP_ID
, LOG.DBID
, LOG.INSTANCE_NUMBER
, GROUP#
, THREAD#
, SEQUENCE#
, BYTES
, MEMBERS
, ARCHIVED
, LOG.STATUS
, FIRST_CHANGE#
, FIRST_TIME
, DECODE(LOG.CON_DBID
, 0
, LOG.DBID
, LOG.CON_DBID)
, 0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_LOG LOG
WHERE SN.SNAP_ID = LOG.SNAP_ID
AND SN.DBID = LOG.DBID
AND SN.INSTANCE_NUMBER = LOG.INSTANCE_NUMBER