select s.snap_id, s.dbid, s.cell_hash,
s.begin_time, s.seq_no, s.message,
decode(s.stateful,1,'Y','N') stateful,
s.severity,
s.cell_alert_summary,
decode(s.con_dbid, 0, s.dbid, s.con_dbid),
0 con_id
from WRH$_CELL_OPEN_ALERTS s,
(select distinct snap_id, dbid
from DBA_HIST_SNAPSHOT) sn
where s.snap_id = sn.snap_id
and s.dbid = sn.dbid
SELECT S.SNAP_ID
, S.DBID
, S.CELL_HASH
,
S.BEGIN_TIME
, S.SEQ_NO
, S.MESSAGE
,
DECODE(S.STATEFUL
, 1
, 'Y'
, 'N') STATEFUL
,
S.SEVERITY
,
S.CELL_ALERT_SUMMARY
,
DECODE(S.CON_DBID
, 0
, S.DBID
, S.CON_DBID)
,
0 CON_ID
FROM WRH$_CELL_OPEN_ALERTS S
,
(SELECT DISTINCT SNAP_ID
, DBID
FROM DBA_HIST_SNAPSHOT) SN
WHERE S.SNAP_ID = SN.SNAP_ID
AND S.DBID = SN.DBID
|
|
|