Re: want to know the growth of my oracle database

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 25 Sep 2005 23:09:50 +0200
Message-ID: <6d4ej15jve2k0mqv8julibh4f9t4vag8gi@4ax.com>

On 25 Sep 2005 10:49:55 -0700, chennakeshava_ramesh_at_yahoo.co.in wrote:

>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.
>
>thanks and regards
>RAMESH.
It doesn't. OEM seems to have facilities for this. Toad has a tablespace manager, and Quest Central has something similar. Evidently all those products create extra tables.

If you are running Statspack you could try something to do with the data collected there

--
Sybrand Bakker, Senior Oracle DBA

Received on Sun Sep 25 2005 - 16:09:50 CDT