Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Capacity Planning

raimraim Member Posts: 1

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
can capture
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.

Sign In or Register to comment.