SQL> run
1* select * from dba_data_files order by tablespace_name
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
G:\ORACLE\ORADATA\ENCYNEW\ENCYDATOS07.DBF
25 ENCY_DATOS 4294967296 524288 AVAILABLE
25 NO 0 0 0 4293918720 524160
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
G:\ORACLE\ORADATA\ENCYNEW\ENCYDATOS06.DBF
22 ENCY_DATOS 4294967296 524288 AVAILABLE
22 NO 0 0 0 4293918720 524160
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
G:\ORACLE\ORADATA\ENCYNEW\ENCYDATOS05.DBF
9 ENCY_DATOS 4294967296 524288 AVAILABLE
9 NO 0 0 0 4293918720 524160
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
G:\ORACLE\ORADATA\ENCYNEW\ENCYDATOS04.DBF
8 ENCY_DATOS 4294967296 524288 AVAILABLE
8 NO 0 0 0 4293918720 524160
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
G:\ORACLE\ORADATA\ENCYNEW\ENCYDATOS01.DBF
5 ENCY_DATOS 4294967296 524288 AVAILABLE
5 NO 0 0 0 4293918720 524160
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
G:\ORACLE\ORADATA\ENCYNEW\ENCYDATOS02.DBF
6 ENCY_DATOS 4294967296 524288 AVAILABLE
6 NO 0 0 0 4293918720 524160
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
G:\ORACLE\ORADATA\ENCYNEW\ENCYDATOS03.DBF
7 ENCY_DATOS 4294967296 524288 AVAILABLE
7 NO 0 0 0 4293918720 524160
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
H:\ORACLE\ORADATA\ENCYNEW\ENCY_INDICES02.DBF
14 ENCY_INDICES 2411724800 294400 AVAILABLE
14 NO 0 0 0 2410676224 294272
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
H:\ORACLE\ORADATA\ENCYNEW\ENCY_INDICES08.DBF
26 ENCY_INDICES 2411724800 294400 AVAILABLE
26 NO 0 0 0 2410676224 294272
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
H:\ORACLE\ORADATA\ENCYNEW\ENCY_INDICES07.DBF
21 ENCY_INDICES 2411724800 294400 AVAILABLE
21 NO 0 0 0 2410676224 294272
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
H:\ORACLE\ORADATA\ENCYNEW\ENCY_INDICES01.DBF
15 ENCY_INDICES 2411724800 294400 AVAILABLE
15 NO 0 0 0 2410676224 294272
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
H:\ORACLE\ORADATA\ENCYNEW\ENCY_INDICES09.DBF
27 ENCY_INDICES 2411724800 294400 AVAILABLE
27 NO 0 0 0 2410676224 294272
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
H:\ORACLE\ORADATA\ENCYNEW\ENCY_INDICES03.DBF
13 ENCY_INDICES 2411724800 294400 AVAILABLE
13 NO 0 0 0 2410676224 294272
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
H:\ORACLE\ORADATA\ENCYNEW\ENCY_INDICES04.DBF
12 ENCY_INDICES 2411724800 294400 AVAILABLE
12 NO 0 0 0 2410676224 294272
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
H:\ORACLE\ORADATA\ENCYNEW\ENCY_INDICES05.DBF
11 ENCY_INDICES 2411724800 294400 AVAILABLE
11 NO 0 0 0 2410676224 294272
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
H:\ORACLE\ORADATA\ENCYNEW\ENCY_INDICES06.DBF
10 ENCY_INDICES 2411724800 294400 AVAILABLE
10 NO 0 0 0 2410676224 294272
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
K:\ORACLE\ORADATA\ENCYNEW\GDN_DATOS02.DBF
16 GDN_DATOS 524288000 64000 AVAILABLE
16 NO 0 0 0 523239424 63872
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
K:\ORACLE\ORADATA\ENCYNEW\GDN_DATOS01.DBF
17 GDN_DATOS 524288000 64000 AVAILABLE
17 NO 0 0 0 523239424 63872
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
L:\ORACLE\ORADATA\ENCYNEW\GDN_INDICES02.DBF
18 GDN_INDICES 209715200 25600 AVAILABLE
18 NO 0 0 0 208666624 25472
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
L:\ORACLE\ORADATA\ENCYNEW\GDN_INDICES04.DBF
23 GDN_INDICES 209715200 25600 AVAILABLE
23 NO 0 0 0 208666624 25472
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
L:\ORACLE\ORADATA\ENCYNEW\GDN_INDICES03.DBF
20 GDN_INDICES 209715200 25600 AVAILABLE
20 NO 0 0 0 208666624 25472
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
L:\ORACLE\ORADATA\ENCYNEW\GDN_INDICES01.DBF
19 GDN_INDICES 209715200 25600 AVAILABLE
19 NO 0 0 0 208666624 25472
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
F:\ORACLE\ORADATA\ENCYNEW\SYSAUX01.DBF
2 SYSAUX 1258291200 153600 AVAILABLE
2 YES 3.4360E+10 4194302 1280 1257242624 153472
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
F:\ORACLE\ORADATA\ENCYNEW\SYSTEM01.DBF
1 SYSTEM 1635778560 199680 AVAILABLE
1 YES 3.4360E+10 4194302 1280 1634729984 199552
SYSTEM
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
F:\ORACLE\ORADATA\ENCYNEW\TS_AUDIT01.DBF
24 TS_AUD 1153433600 140800 AVAILABLE
24 NO 0 0 0 1152385024 140672
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
F:\ORACLE\ORADATA\ENCYNEW\UNDOTBS01.DBF
3 UNDOTBS1 1.1660E+10 1423360 AVAILABLE
3 YES 3.4360E+10 4194302 640 1.1659E+10 1423232
ONLINE
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
F:\ORACLE\ORADATA\ENCYNEW\USERS01.DBF
4 USERS 41943040 5120 AVAILABLE
4 YES 3.4360E+10 4194302 160 40894464 4992
ONLINE
27 rows selected.
----------------------
SQL> run
1* select tablespace_name, sum(bytes) from dba_free_space group by tablespace_name
TABLESPACE_NAME SUM(BYTES)
------------------------------ ----------
TS_AUD 270991360
SYSAUX 73269248
UNDOTBS1 1.1618E+10
ENCY_INDICES 5063639040
GDN_DATOS 420675584
GDN_INDICES 352321536
USERS 40566784
SYSTEM 876609536
ENCY_DATOS 6082985984
9 rows selected.