Ben wrote:
> 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.
Not sure if this is in 9.2.0.5 but you can check:
DBMS_SPACE.OBJECT_GROWTH_TREND
DBMS_SPACE.OBJECT_GROWTH_TREND_SWRF
DBMS_SPACE.OBJECT_SPACE_USAGE
DBMS_SPACE.OBJECT_SPACE_USAGE_TBF
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Wed Sep 20 2006 - 14:06:15 CDT
