select sga.snap_id, sga.dbid, sga.instance_number, name, pool, bytes,
decode(sga.con_dbid, 0, sga.dbid, sga.con_dbid),
0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_SGASTAT sga
where sn.snap_id = sga.snap_id
and sn.dbid = sga.dbid
and sn.instance_number = sga.instance_number
SELECT SGA.SNAP_ID
, SGA.DBID
, SGA.INSTANCE_NUMBER
, NAME
, POOL
, BYTES
,
DECODE(SGA.CON_DBID
, 0
, SGA.DBID
, SGA.CON_DBID)
,
0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_SGASTAT SGA
WHERE SN.SNAP_ID = SGA.SNAP_ID
AND SN.DBID = SGA.DBID
AND SN.INSTANCE_NUMBER = SGA.INSTANCE_NUMBER
|
|
|