Re: want to know the growth of my oracle database

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.

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.
Received on Sun Sep 25 2005 - 23:51:22 CDT