database free space

Hi All,

I am trying to get the total free space in the database and using DBA_FREE_SPACE view.Could anybody tell me that it includes the free space in logs also ? Could you tell me exactly how to determine the free space ?

Thanks in advance.

---Radha

dba free space tells the free space of each tablespaces. you sum them up you get the free space of all datafiles

it hasnt got anything to do with logfiles

SELECT A.TABLESPACE_NAME TABLESPACE,
ROUND(A.BYTES/1048576,1) MB_TOTAL,
ROUND(NVL(B.BYTES/1048576, 0), 1) MB_USILISE,
ROUND(((NVL(B.BYTES,0) * 100) / A.BYTES), 1) "UTILISATION(%)"
FROM (select tablespace_name, sum(bytes) bytes
from dba_data_files
group by tablespace_name) A,
(select tablespace_name,
sum(bytes) bytes
from dba_extents
group by tablespace_name) B
WHERE A.TABLESPACE_NAME = B.TABLESPACE_NAME (+)
ORDER BY 1;


Steeve Bisson
Email:[email protected]