Guest User | Contact

Frequently Asked Questions

Free space in Tablespace Script

We need to monitor free space in every tablespace for maintaining database up and running without any issue. Always check and monitor tablespace available space and used space in every database. You should need to change this script as per Oracle version.

column "Tablespace" format a13
column "Used MB"    format 99,999,999
column "Free MB"    format 99,999,999
column "Total MB"   format 99,999,999
select
   fs.tablespace_name                          "Tablespace",
   (df.totalspace - fs.freespace)              "Used MB",
   fs.freespace                                "Free MB",
   df.totalspace                               "Total MB",
   round(100 * (fs.freespace / df.totalspace)) "Pct. Free"
from
   (select
      tablespace_name,
      round(sum(bytes) / 1048576) TotalSpace
   from
      dba_data_files
   group by
      tablespace_name
   ) df,
   (select
      tablespace_name,
      round(sum(bytes) / 1048576) FreeSpace
   from
      dba_free_space
   group by
      tablespace_name
   ) fs
where
   df.tablespace_name = fs.tablespace_name;


We need to monitor tablespace space as well as operating system space too. If you need more assistance open support ticket.

 Last updated Tue, Sep 29 2015 10:46am

Please Wait!

Please wait... it will take a second!