DBA Data[Home] [Help]

VIEW: SYS.DBA_HIST_IM_SEG_STAT

Source

View Text - Preformatted

select "SNAP_ID","DBID","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","CON_DBID","CON_ID" from INT$DBA_HIST_IM_SEG_STAT
View Text - HTML Formatted

SELECT "SNAP_ID"
, "DBID"
, "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"
, "CON_DBID"
, "CON_ID"
FROM INT$DBA_HIST_IM_SEG_STAT