HOW TO CHECK ORACLE TABLESAPCE USAGE

OPEN SQLPLUS —

sqlplus / as sysdba

Execute below query :

select a.TABLESPACE_NAME, round(total,1) Total_M, round(free) Free_M, round(100*(1-free/total),1) Usage
from (select TABLESPACE_NAME,sum(BYTES)/(1024*1024) total from dba_data_files group by TABLESPACE_NAME) a
,(select TABLESPACE_NAME,sum(BYTES)/(1024*1024) free from dba_free_space group by TABLESPACE_NAME) b
where a.TABLESPACE_NAME=b.TABLESPACE_NAME(+) order by 4 DESC;

Output will show all tablesapce usages :




Leave a Reply

Your email address will not be published. Required fields are marked *