# # Copyrights, SIA CoMinder, http://www.cominder.eu/, 2012-2013 # # About: CoMinder SpaceStat version changes information # and features requests. # # Terminology: (+) - new feature (-) - removed feature (=) - improvement or bug-fix # ============ Version Changes ================= # 2011.12.28: 0.50: (+) 1st version using repository in DB for all remote DBs # : snapshots segments types supported: Segments (dba_segments) # : used for CoMinder Support usage only # 2012.02.16: 0.51: (=) for each DB personally, no need central repository and DB-links # : repository DB may be supported in later versions # : snapshots segments types supported: Segments (dba_segments), Files (dba_data|temp_files) # 2012.05.22: 0.52: (=) do all segments types snapshoting in one all: snap_type=ALL - internally implemeted as 2 snaps with the same snap-id # : this is may be more convinient for reporting, but old style also supported # : (+) some new reports added # 2012.06.27: 0.53: (=) this README.txt improved. 1st published version. # : (+) support of redo-logs and control-file in Files (DBF) snapshot type # : (=) improved table structures, indexes and constraints, # : also to keep info from multiple databases, but really not tested in this context # 2012.10.16: 0.54:(+) added old unnecessary data purging (F.6 request) # : SPS_SETTINGS table and SPS_PURGE procedure for purging too old statistics # : retention policy can be set for serveral types of periods # : daily - to keep daily data, weekly - to keep one snap per week, monthly and yearly # : see cfg/cfg_settings.sql and sps_purge.sql|.sh for more details # : (=) cre_tablespaces.sql - we recommend to use UNIFORM sized, but auto-managed tablespace # : (=) fixed bug 0.53.01 with SPS_VERSION create DDL # : (=) sps_snap.sh now use oraenv call instead of hardcoded values # : Reporting improvements: # : (+) sps_autoreport_by_month.sql - use to get regular reports at once for 1 month: # : * sps_report_delta_db.sql - changes summary for whole DB # : * sps_report_delta_details.sql - changes details per segment # : * sps_report_top.sql - top 100 biggest segments # : (+) sps_report_snaps_actual.sql - reports actual snapshots according to retention settings # : (+) sps_report_snaps_obsolete.sql - lists obsolete snapshots, may be usefull before calling sps_purge. # : (+) db_report_empty_tbs.sql - reports empty tablespaces and generates SQL to drop them (be carefull!!) # 2013.04.17: 0.55: In general bug-fix version and minimal improvements # : (=) fixed bugs: 0.54.01,0.54.03,0.54.03,0.54.04 # : this makes SpaceStat usable in version 10g+ - see details in BUGHIST.txt # : (=) snapshoting and purging scripts (sps*.sql, sps*.sh) moved to bin directory # : (+) UNDO tablespace files now registered as 'UNDO_FILE' instead of 'DATA_FILE' - may be useful for reporting # : (=) non-partitioned tables have '--NONE--' in PARTITION_NAME field of SPS_SNAP_DATA - I see it is better then function-based index # : (=) updated report sps_report_top.sql - now segment size is sum of all partitions # : (=) renamed report sps_autoreport_by_month.sql to sps_report_for_month.sql # : (+) new reports: # : * sps_report_for_period - the same as sps_report_for_month.sql, but for any interval # : * sps_version.sql - SpaceStat versions history and components # : * sps_report_dynamo_db - Database size dynamic for period: whole DB and grouped by segment/type # : (=) Bugs found and fix info moved from CHANGELOG.txt to BUGHIST.txt # ============ Features Requests (by author and contributors) ================ 26.06.2012 F.1 - customize installation to be able install: a) in custom tablespace(s) b) tables independent from indexes - this may be usefull for DB with huge number of segments and long history F.2 - load and process OS info by: host, user, dir, file F.3 - size monitoring for exact objects or group using default policy (or per object) for % or bytes changes for period F.4 - container/child audit - special report new objects appeared in containers (tablepsace, schema,..) that should not have anything new. For now - just use delta report for all new/dropped/changed segments in DB F.5 - one repository for storing many targets info F.6 - (already implemented) - purge old data 17.01.2013 F.7 - ASM information snapshoting and reporting F.8 - Automate installation where possible (work in progress) F.9 - Reports in HTML format F.10 - Space requirements forecasting based on existing statistics # End Of File