select pga.snap_id, pga.dbid, pga.instance_number, name, value,
decode(pga.con_dbid, 0, pga.dbid, pga.con_dbid),
0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_PGASTAT pga
where sn.snap_id = pga.snap_id
and sn.dbid = pga.dbid
and sn.instance_number = pga.instance_number
SELECT PGA.SNAP_ID
, PGA.DBID
, PGA.INSTANCE_NUMBER
, NAME
, VALUE
,
DECODE(PGA.CON_DBID
, 0
, PGA.DBID
, PGA.CON_DBID)
,
0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_PGASTAT PGA
WHERE SN.SNAP_ID = PGA.SNAP_ID
AND SN.DBID = PGA.DBID
AND SN.INSTANCE_NUMBER = PGA.INSTANCE_NUMBER
|
|
|