We are trying to do Capacity planning for our oracle 9i database,
But we have no budget to buy tools like Enterprise Manager's Capacity
Planning pack etc.
Please does anyone have something like a home grown tool that
could be used for this purpose. Ideally I will appreciate a tool that
1. Growth in tablespaces
2. Growth in key tables
and be able to display that over time, at least historically and (ideally) as a forward projection.
Best option will be a tool that can captured data regularly and somehow be able to graph it.
If the above tool is not available.
A SQL code, procedure etc that can capture the above information (capacity planning info)
and store it in a table in the database will be equally appreciated.