#
# 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                                                     