Forgot your password?
Document Actions
How to list the percentage of tablespace usage on Oracle
Statement to list the percentage of tablespace usage
col BYTES format 999G999G999G999G999;
col MBYTES format 999G999G999G999D999;
col FILE_NAME format a70;
select A.TABLESPACE_NAME, A.BYTES, A.BYTES/1024/1024 as MBYTES, B.FILE_NAME
from DBA_FREE_SPACE A,
DBA_DATA_FILES B
where A.TABLESPACE_NAME like '&TBS_NAME'
and A.FILE_ID = B.FILE_ID
order by 1,3 desc;
Hacker Rangers - Gamification for CyberSecurity