How to find used and free space for individual data file in the database ?
Printable View
How to find used and free space for individual data file in the database ?
Use the dba_free_space by giving the file_id (freespace)
dba_data_files (total size)
total-free=used