VIEW: SYS.INT$DBA_HIST_ASM_BAD_DISK

Source

View Text - Preformatted

select tb.snap_id, tb.dbid,
       GROUP_NUMBER, NAME, PATH, STATUS,
       decode(con_dbid, 0, tb.dbid, con_dbid),
       0 con_id
  from (select distinct snap_id, dbid
          from DBA_HIST_SNAPSHOT) sn,
       WRH$_ASM_BAD_DISK tb
  where sn.snap_id = tb.snap_id
    and sn.dbid    = tb.dbid

View Text - HTML Formatted

SELECT TB.SNAP_ID
, TB.DBID
, GROUP_NUMBER
, NAME
, PATH
, STATUS
, DECODE(CON_DBID
, 0
, TB.DBID
, CON_DBID)
, 0 CON_ID
FROM (SELECT DISTINCT SNAP_ID
, DBID
FROM DBA_HIST_SNAPSHOT) SN
, WRH$_ASM_BAD_DISK TB
WHERE SN.SNAP_ID = TB.SNAP_ID
AND SN.DBID = TB.DBID