SYS @ prod >select file_id,file_name,tablespace_name,bytes/1024/1024 from dba_data_files;
FILE_ID FILE_NAME TABLESPACE_NAME BYTES/1024/1024
---------- -------------------------------------------------- ------------------------------ ---------------
1 /u01/app/oracle/oradata/prod/system01.dbf SYSTEM 1024
2 /u01/app/oracle/oradata/prod/lx01.dbf LX01 30
3 /u01/app/oracle/oradata/prod/sysaux01.dbf SYSAUX 260
4 /u01/app/oracle/oradata/prod/users01.dbf USERS 158.75
5 /u01/app/oracle/oradata/prod/test01.dbf TEST 7
6 /u01/app/oracle/oradata/prod/test02.dbf TEST 5
8 /u01/app/oracle/oradata/prod/test04.dbf TEST 5
7 /u01/app/oracle/oradata/prod/undotbs02.dbf UNDOTBS2 100
9 /u01/app/oracle/oradata/prod/lx02.dbf LX02 30
10 /u01/app/oracle/oradata/prod/lx03.dbf LX03 30
11 /u01/app/oracle/oradata/prod/lx04.dbf LX04 30
12 /u01/app/oracle/oradata/prod/index01.dbf INDEXES 50
13 /u01/app/oracle/oradata/prod/perftbs1.dbf PERFTBS 100