select l.snap_id, l.dbid, l.instance_number, parent_name, where_in_code,
nwfail_count, sleep_count, wtr_slp_count,
decode(l.con_dbid, 0, l.dbid, l.con_dbid),
0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_LATCH_MISSES_SUMMARY l
where l.snap_id = sn.snap_id
and l.dbid = sn.dbid
and l.instance_number = sn.instance_number
SELECT L.SNAP_ID
, L.DBID
, L.INSTANCE_NUMBER
, PARENT_NAME
, WHERE_IN_CODE
,
NWFAIL_COUNT
, SLEEP_COUNT
, WTR_SLP_COUNT
,
DECODE(L.CON_DBID
, 0
, L.DBID
, L.CON_DBID)
,
0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_LATCH_MISSES_SUMMARY L
WHERE L.SNAP_ID = SN.SNAP_ID
AND L.DBID = SN.DBID
AND L.INSTANCE_NUMBER = SN.INSTANCE_NUMBER
|
|
|