database growth script

[ndisang]

For the size of your database as of today at a glance (nothing fancy)
you can
1/ SQL> select sum(bytes)/1024/1024 from dba_data_files;


2/SQL> select sum(bytes)/1024/1024 from dba_FREE_Space;

then:
SQL> select (value1) - (value2) from dual;


or simply:

SQL> select sum(bytes)/1024/1024 from dba_extents;

All in Megs