select sp.snap_id, sp.dbid, sp.instance_number,
size_for_estimate, size_factor,
estd_spill_count, estd_spill_time,
estd_unspill_count, estd_unspill_time,
decode(sp.con_dbid, 0, sp.dbid, sp.con_dbid),
0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_STREAMS_POOL_ADVICE sp
where sn.snap_id = sp.snap_id
and sn.dbid = sp.dbid
and sn.instance_number = sp.instance_number
SELECT SP.SNAP_ID
, SP.DBID
, SP.INSTANCE_NUMBER
,
SIZE_FOR_ESTIMATE
, SIZE_FACTOR
,
ESTD_SPILL_COUNT
, ESTD_SPILL_TIME
,
ESTD_UNSPILL_COUNT
, ESTD_UNSPILL_TIME
,
DECODE(SP.CON_DBID
, 0
, SP.DBID
, SP.CON_DBID)
,
0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_STREAMS_POOL_ADVICE SP
WHERE SN.SNAP_ID = SP.SNAP_ID
AND SN.DBID = SP.DBID
AND SN.INSTANCE_NUMBER = SP.INSTANCE_NUMBER
|
|
|