Capacity planning - Responses Highly Appreciated.

[phraim]

Hello,

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.

Thanks
Phraim

[tamilselvan]

No estimation would give you a correct picture.
Today the disk price is cheap.
Do not waste your time on doing capacity planning.

Tamil

[DaPi]

I too think you are better off buying disk rather than some software for this. However, you do need to get some kind of handle on growth - the scripts section of this site might help (e.g. I saw this http://www.dbasupport.com/oracle/scr...iled/130.shtml which might give you a kick-start - I've never used it though).

[phraim]

Thanks Tamil and Dapi for your response to my question.
Your responses were very helpful.

Thanks again,
IPhraim