Free space in a datafile

Hi folks,
How to findout the filled space and free space in
a datafile

Regards
sonia

Not sure, I always use OEM for this. Do you have OEM?

MH

Try the select tablespace_name, bytes/1024/1024 "Free Space" from dba_free_space;

Sorry, I miss read the sentence, Normally I will use the DBA Studio or OEM.... Faster and easier.

Code:

---

SELECT Substr(df.tablespace_name,1,20) "Tablespace_Name",
      Substr(df.file_name,1,40) "File_Name",
      Round(df.bytes/1024/1024,2) "Size_(M)",
      Round(e.used_bytes/1024/1024,2) "Used_(M)",
      Round(f.free_bytes/1024/1024,2) "Free_(M)",
      Rpad(' '|| Rpad ('X',Round(e.used_bytes*10/df.bytes,0), 'X'),11,'-') "%_Used"
FROM  DBA_DATA_FILES DF,
      (SELECT file_id,
              Sum(Decode(bytes,NULL,0,bytes)) used_bytes
        FROM dba_extents
        GROUP by file_id) E,
      (SELECT Max(bytes) free_bytes,
              file_id
        FROM dba_free_space
        GROUP BY file_id) f
WHERE  e.file_id (+) = df.file_id
AND    df.file_id  = f.file_id (+)
ORDER BY df.tablespace_name, df.file_name

---

HTH

Sameer