database free space

[rsonnathi]

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

[pando]

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

[steeve123]

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]