select lc.snap_id, lc.dbid, lc.instance_number, namespace, gets,
gethits, pins, pinhits, reloads, invalidations,
dlm_lock_requests, dlm_pin_requests, dlm_pin_releases,
dlm_invalidation_requests, dlm_invalidations,
decode(lc.con_dbid, 0, lc.dbid, lc.con_dbid),
0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_LIBRARYCACHE lc
where sn.snap_id = lc.snap_id
and sn.dbid = lc.dbid
and sn.instance_number = lc.instance_number
SELECT LC.SNAP_ID
, LC.DBID
, LC.INSTANCE_NUMBER
, NAMESPACE
, GETS
,
GETHITS
, PINS
, PINHITS
, RELOADS
, INVALIDATIONS
,
DLM_LOCK_REQUESTS
, DLM_PIN_REQUESTS
, DLM_PIN_RELEASES
,
DLM_INVALIDATION_REQUESTS
, DLM_INVALIDATIONS
,
DECODE(LC.CON_DBID
, 0
, LC.DBID
, LC.CON_DBID)
,
0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_LIBRARYCACHE LC
WHERE SN.SNAP_ID = LC.SNAP_ID
AND SN.DBID = LC.DBID
AND SN.INSTANCE_NUMBER = LC.INSTANCE_NUMBER
|
|
|