select tbs.snap_id, tbs.dbid, tbs.instance_number, ts#, tsname, contents,
tbs.status, segment_space_management, extent_management,
is_backup,
decode(tbs.con_dbid, 0, tbs.dbid, tbs.con_dbid),
con_dbid_to_id(decode(tbs.con_dbid, 0, tbs.dbid, tbs.con_dbid)) con_id
from DBA_HIST_SNAPSHOT sn, WRH$_TABLESPACE_STAT tbs
where tbs.snap_id = sn.snap_id
and tbs.dbid = sn.dbid
and tbs.instance_number = sn.instance_number
SELECT TBS.SNAP_ID
, TBS.DBID
, TBS.INSTANCE_NUMBER
, TS#
, TSNAME
, CONTENTS
,
TBS.STATUS
, SEGMENT_SPACE_MANAGEMENT
, EXTENT_MANAGEMENT
,
IS_BACKUP
,
DECODE(TBS.CON_DBID
, 0
, TBS.DBID
, TBS.CON_DBID)
,
CON_DBID_TO_ID(DECODE(TBS.CON_DBID
, 0
, TBS.DBID
, TBS.CON_DBID)) CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_TABLESPACE_STAT TBS
WHERE TBS.SNAP_ID = SN.SNAP_ID
AND TBS.DBID = SN.DBID
AND TBS.INSTANCE_NUMBER = SN.INSTANCE_NUMBER
|
|
|