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