As per the some of the requirements , we have to calculate the Daily increase in Volume (bytes) for a database (it includes some 100 + tables) for the past 30 days.
One way of doing it is calculating the daily growth per table i.e through some date/timestamp column and grouping it and then summing for all the 100 tables .. I would be a very timeconsuming step.
I was just thinking that is there any quick way through dbc tables /views or DBQL to get the Daily increase in volume of the past 30 days.
Maybe you need to tweak a little. The link below can be a good pointer.
Put in a unix script may be.
You can schedule the following SQL as an INSERT to a table: