select m.snap_id, m.dbid, m.instance_number,
mutex_type, location, sleeps, wait_time,
decode(m.con_dbid, 0, m.dbid, m.con_dbid),
0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_MUTEX_SLEEP m
where m.snap_id = sn.snap_id
and m.dbid = sn.dbid
and m.instance_number = sn.instance_number
SELECT M.SNAP_ID
, M.DBID
, M.INSTANCE_NUMBER
,
MUTEX_TYPE
, LOCATION
, SLEEPS
, WAIT_TIME
,
DECODE(M.CON_DBID
, 0
, M.DBID
, M.CON_DBID)
,
0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_MUTEX_SLEEP M
WHERE M.SNAP_ID = SN.SNAP_ID
AND M.DBID = SN.DBID
AND M.INSTANCE_NUMBER = SN.INSTANCE_NUMBER
|
|
|