select seg.snap_id, seg.dbid, seg.instance_number, ts#,
obj#, dataobj#, membytes, scans, scans_delta, db_block_changes,
db_block_changes_delta, populate_cus, populate_cus_delta,
repopulate_cus, repopulate_cus_delta, decode(seg.con_dbid, 0, seg.dbid,
seg.con_dbid),
con_dbid_to_id(decode(seg.con_dbid, 0, seg.dbid, seg.con_dbid)) con_id
from DBA_HIST_SNAPSHOT sn, WRH$_IM_SEG_STAT seg
where
seg.snap_id = sn.snap_id
and seg.dbid = sn.dbid
and seg.instance_number = sn.instance_number
SELECT SEG.SNAP_ID
, SEG.DBID
, SEG.INSTANCE_NUMBER
, TS#
,
OBJ#
, DATAOBJ#
, MEMBYTES
, SCANS
, SCANS_DELTA
, DB_BLOCK_CHANGES
,
DB_BLOCK_CHANGES_DELTA
, POPULATE_CUS
, POPULATE_CUS_DELTA
,
REPOPULATE_CUS
, REPOPULATE_CUS_DELTA
, DECODE(SEG.CON_DBID
, 0
, SEG.DBID
,
SEG.CON_DBID)
,
CON_DBID_TO_ID(DECODE(SEG.CON_DBID
, 0
, SEG.DBID
, SEG.CON_DBID)) CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_IM_SEG_STAT SEG
WHERE
SEG.SNAP_ID = SN.SNAP_ID
AND SEG.DBID = SN.DBID
AND SEG.INSTANCE_NUMBER = SN.INSTANCE_NUMBER
|
|
|