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.