- Timestamp:
- 08/18/09 15:17:02 (9 years ago)
- Files:
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
trunk/table_growth/otools.summarize_table_growth.sql
r26 r47 9 9 IF to_char(current_date,'dd') <> '01' THEN 10 10 insert into otools.table_growth (table_owner, schema_name, table_name, actual_size, growth_size, sum_flag, capture_time) 11 select a.table_owner, a.schema_name, a.table_name, a.actual_size, a.actual_size-coalesce(b.actual_size, 0) AS table_growth, 1, a.capture_time11 select a.table_owner, a.schema_name, a.table_name, a.actual_size, a.actual_size-coalesce(b.actual_size,a.actual_size) AS table_growth, 1, a.capture_time 12 12 from otools.table_growth a 13 13 left join otools.table_growth b