More on Oracle Space Management Scripts

(We marked visited pages blue)
  • Script to list Oracle tablespace usage
  • Script to find schema size in Oracle
  • Script to find Database size in Oracle
  • Oracle Script to list space usage per data file

    The script will list the space usage per data file and orders them descending by usage percentage.

    select fn.file_name filename,
           fn.tablespace_name tsname,
           ff.free_space free_space,
           fn.bytes / 1000000 All_space,
           fn.bytes / 1000000 - ff.free_space used_space,
           1 - ff.free_space / (fn.bytes / 1000000) used_pct
      from sys.dba_data_files fn, file_free ff
     where fn.file_id = ff.file_id
     order by used_pct desc ;


    Leave a comment or a question in the comment area bellow if you fell like


    Be a sport and

    Search

    Loading... Please wait

    Subscribe to our Newsletter

    Be a sport and

    x