Re: want to know the growth of my oracle database

Comments embedded.
endrue wrote:
> Maybe U can try this.
>
> select to_char(creation_time, 'RRRR Month') "Month",
> sum(bytes)/1024/1024
> "Growth in Meg"
> from sys.v_$datafile
> where creation_time > SYSDATE-365
> group by to_char(creation_time, 'RRRR
> Month');
>
> Andrew E.K.
>

What information does this provide outside of reporting when a particular datafile was created within the last 365 days and how large it is? This has no real value as a stand-alone query, much less as an indicator of tablespace/database growth. There may be datafiles older than 365 days prior to the current date, and the size of a datafile does not necessarily indicate the rate of growth of a database.

>
> 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.
Using DBMS_STATS on a regular basis, and querying DBA_TABLES and DBA_INDEXES will probably provide better data to track database growth.  You could store these statistics in a history table to enable forecasting although this would consume some additional space you may not have or may not want to allocate. You migfht also try using the DBMS_ROWID package, to report populated blocks; you could track this total over a period of time, on a per-table basis, and see not only your growth but which tables are growing faster than others. You have a number of options, any of which I'll be happy to discuss with you offline.

David Fitzjarrell Received on Mon Sep 26 2005 - 12:52:41 CDT