select dlm.snap_id, dlm.dbid, dlm.instance_number,
statistic#, name, value,
decode(dlm.con_dbid, 0, dlm.dbid, dlm.con_dbid),
0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_DLM_MISC dlm
where sn.snap_id = dlm.snap_id
and sn.dbid = dlm.dbid
and sn.instance_number = dlm.instance_number
SELECT DLM.SNAP_ID
, DLM.DBID
, DLM.INSTANCE_NUMBER
,
STATISTIC#
, NAME
, VALUE
,
DECODE(DLM.CON_DBID
, 0
, DLM.DBID
, DLM.CON_DBID)
,
0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_DLM_MISC DLM
WHERE SN.SNAP_ID = DLM.SNAP_ID
AND SN.DBID = DLM.DBID
AND SN.INSTANCE_NUMBER = DLM.INSTANCE_NUMBER
|
|
|