select eq.snap_id, eq.dbid, eq.instance_number,
eq_type, req_reason, total_req#,
total_wait#, succ_req#, failed_req#, cum_wait_time, event#,
decode(eq.con_dbid, 0, eq.dbid, eq.con_dbid),
con_dbid_to_id(decode(eq.con_dbid, 0, eq.dbid, eq.con_dbid)) con_id
from DBA_HIST_SNAPSHOT sn, WRH$_ENQUEUE_STAT eq
where sn.snap_id = eq.snap_id
and sn.dbid = eq.dbid
and sn.instance_number = eq.instance_number
SELECT EQ.SNAP_ID
, EQ.DBID
, EQ.INSTANCE_NUMBER
,
EQ_TYPE
, REQ_REASON
, TOTAL_REQ#
,
TOTAL_WAIT#
, SUCC_REQ#
, FAILED_REQ#
, CUM_WAIT_TIME
, EVENT#
,
DECODE(EQ.CON_DBID
, 0
, EQ.DBID
, EQ.CON_DBID)
,
CON_DBID_TO_ID(DECODE(EQ.CON_DBID
, 0
, EQ.DBID
, EQ.CON_DBID)) CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_ENQUEUE_STAT EQ
WHERE SN.SNAP_ID = EQ.SNAP_ID
AND SN.DBID = EQ.DBID
AND SN.INSTANCE_NUMBER = EQ.INSTANCE_NUMBER
|
|
|