
/* 
  Cominder SpaceStat - list of SQL-files for reporting 
  version 0.55, 2013.06.16
  
*/

-- reports introduced in 0.53 -- 
reports/sps_list_snaps.sql        -- just list snapshots in the system - used by all reports (for last 42 days - update if need more or less)
reports/sps_report_delta_db.sql   -- delta summary for Files and Segments in one report (really executes the same SQL as report_delta_db)
reports/sps_report_delta_any.sql  -- delta summary for any segment type - snaps id should be provided
reports/sps_report_delta_details.sql      -- delta details for any segment type - snaps id should be provided
reports/sps_report_delta_details_tbs.sql  -- delta details for any segment type - with filter by TBS mask         
reports/sps_report_top.sql        -- top 100 segments by bytes used

-- reports introduced in 0.54 -- 
reports/sps_autoreport_by_month.sql - Use to get regular reports at once for 1 month.
-- NOTE! in 0.55 renamed to reports/sps_report_for_month.sql. See description below.
 
reports/sps_report_snaps_actual.sql - reports actual snapshots according to retention settings
reports/sps_report_snaps_obsolete.sql - lists obsolete snapshots, may be usefull before calling sps_purge.

reports/db_report_empty_tbs.sql - reports currently empty tablespaces in DB (from dba_segments,not from snapshots!)
                                   and generates SQL to drop them (be carefull!!)
                                   
                                      
-- reports introduced in 0.55 --
reports/sps_version.sql             -- Show SpaceStat installation history and objects in database
reports/sps_report_for_month.sql    -- Use to get regular reports at once for 1 month.
    You should set spooling to report-file befoire call. 
    After asking month in format YYYY.MM it will call 3 reports:
    * sps_report_delta_db.sql
    * sps_report_delta_details.sql
    * sps_report_top.sql - top 100 biggest segments
    NOTE: interval formula is: start_time  BETWEEN to_date('&month_expr..01','YYYY.MM.DD') and 2+last_day(to_date('&month_expr..01','YYYY.MM.DD'))
          so begin snap is 01. of the month X, and the end snap is 01. of the month X+1
          adjust if required.    

reports/sps_report_for_period.sql   -- The same, but or any period
    NOTE: interval formula is:  start_time  BETWEEN to_date('&p_date_start','YYYY.MM.DD') and to_date('&p_date_end','YYYY.MM.DD')
          adjust if required
          
reports/sps_report_dynamo_db.sql    -- Database size dynamic for period: whole DB and grouped by segment/type 
                                                   