Systemista

[oracle]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Aug 23 12:05:30 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> select tablespace_name, sum(bytes/1024/1024) "MB FREE" from dba_free_space group by tablespace_name order by 1;

TABLESPACE_NAME MB FREE
------------------------------ --------------
DATA_01 39018.6875
DATA_02 84999.6875
DATA_03 94999.625
DATA_04 94999.625
DATA_05 24855.875
DATA_06 59999.75
IDX_01 10856.0625
IDX_02 14999.9375
IDX_03 52999.75
PERFSTAT 856.1875
SYSAUX 696.9375

TABLESPACE_NAME MB FREE
------------------------------ --------------
SYSTEM 576
TOOLS 981.9375
UNDOTBS1 27864.0625
UNDOTBS2 29905.375
USERS 992.3125

16 rows selected.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
[oracle]$