select s.snap_id, s.dbid, s.cell_hash, s.incarnation_num,
s.metric_id, nm.metric_name, s.metric_value,
decode(s.con_dbid, 0, s.dbid, s.con_dbid),
0 con_id
from WRH$_CELL_GLOBAL s,
WRH$_CELL_METRIC_DESC nm,
(select distinct snap_id, dbid
from DBA_HIST_SNAPSHOT) sn
where s.metric_id = nm.metric_id
and s.dbid = nm.dbid
and s.snap_id = sn.snap_id
and s.dbid = sn.dbid
SELECT S.SNAP_ID
, S.DBID
, S.CELL_HASH
, S.INCARNATION_NUM
,
S.METRIC_ID
, NM.METRIC_NAME
, S.METRIC_VALUE
,
DECODE(S.CON_DBID
, 0
, S.DBID
, S.CON_DBID)
,
0 CON_ID
FROM WRH$_CELL_GLOBAL S
,
WRH$_CELL_METRIC_DESC NM
,
(SELECT DISTINCT SNAP_ID
, DBID
FROM DBA_HIST_SNAPSHOT) SN
WHERE S.METRIC_ID = NM.METRIC_ID
AND S.DBID = NM.DBID
AND S.SNAP_ID = SN.SNAP_ID
AND S.DBID = SN.DBID
|
|
|