Re: want to know the growth of my oracle database

From: Ruud de Koter <nobody_at_internet.org>
Date: Sun, 25 Sep 2005 21:11:09 +0200
Message-ID: <4336f643$0$11069$e4fe514c@news.xs4all.nl>

IANAL_VISTA wrote:
> chennakeshava_ramesh_at_yahoo.co.in wrote in
> news:1127670595.390619.71850_at_g14g2000cwa.googlegroups.com:
>
>

>>Hi,
>>
>>I am trying to predict the growth of my database every month. Is there
>>any tool or method which I can use to predict the growth.
>>
>>Wanted to know whether oracle database only maintains any of these
>>statistics in the data dictionary. 
>>

>
>
> "STATISTICS" about the future?
>
>
> Query V$CRYSTAL_BALL

Ever heard about extrapolation, IANAL?

If that 's what you 're thinking of, Ramesh, you should be able to do something with ALL_TABLES and ALL_INDEXES. Assuming you regularly update the statistics, of course...

Regards,

Ruud. Received on Sun Sep 25 2005 - 14:11:09 CDT