growth of my database

Can any one paste a script that will tell me the growth of my database over the months?

I'm running 8i on RedHat

Check this out

http://www.dbasupport.com/forums/sho...?threadid=5616

Sam

Thank but that only tells me only the size. That is not what I want. I want the growth based on months e.g.

JAN 100m
FEB 80m
MAR 40m, etc

Hi,

You can set up a cron job to run on 1st of every month which runs the query and spools the output to a file (append). You can compare with the previous month and see how much the DB has grown.

There are also some scripts in $ORACLE_HOME/rdbms/admin which allow you to create a schema to keep track of the space.

Baliga