Hello hobbit users,
Three items....
We monitor the size of oracle tables in a similar way as the base disk monitoring is performed. We use a custom script at the back end to create the rrd's as new tablespaces appear (i.e. one tablespace per rrd)
The tablespace sizes are graphed in a similar way to the disk graphs as well with the standard hobbit method of dividing the tables into smaller groups (I think it is 7) and charting them on one graph.
The issue we have is that some tables are very small (say 100MB and some are large 30GBytes). When these are plotted on the same graph, the plots for the small tables are of little value as they look like zero...
I assume the only way to address this would be to plot each table individually. Anyone have any ideas how I can force this?
Next....
I want to stack all the tables onto an area chart to show total database growth. However, the first value needs to be area and the rest of the values stack. How can I achieve this when a regex is used to pick up the rrd's?
And last, I am toying with the idea of trending growth rate. It would seem that the rrd database would make a good source of historical data for this. Has anyone done something here? One idea I am playing with is if a filesystem breaches a capacity threshold out of hours, but the greatest of the last five minute and 30 minute growth rates would indicate that it is not going to run out of space before 10AM on a business day, then don't send me an sms to wake me up. Thoughts?
Phil