Predicting Growth.

Ent Ed. 9.2.0.5, DMT's on AIX5L

There isn't really an accurate way to estimate growth of a database, is there? I have a history of six months of my data file sizes, but even with that there are too many variables envolved to determine that my database is going to continue to grow at a rate of 50 gig per year.

Even if you assume a constant rate of growth, how would you base your projection?

For example, lets say my datafiles grew 25G over the last six months. At the beginning of that six months my database was 100G that is 25% growth over the past six months.
Now looking ahead for a year. My database is now 125G, 25% of that is 31.25G. Then six months down the road the database will be 156.25G, 25% of that is 39.06G, etc etc. But that original 25% figure was calculated from the 100G incarnation of the database. So that won't work. Do I then assume that my database will grow at a constant size instead of %? So my 125G db will be 175G by this time next year. This seems more accurate, but I still think there are just too many unknowns to actually come to an accurate answer. Received on Wed Sep 20 2006 - 12:58:36 CDT