How does Oracle view tablespace usage

This article mainly describes how Oracle view table space utilization, the article is very detailed, has a certain reference value, interested friends must read!

set pagesize 500;

set linesize 1000;

col PER format a10;

col NAME format a20;

SELECT UPPER(F.TABLESPACE_NAME) "NAME",

D.TOT_GROOTTE_MB "TSIZE(M)",

D.TOT_GROOTTE_MB - F.TOTAL_BYTES "USIZE(M)",

TO_CHAR(ROUND((D.TOT_GROOTTE_MB - F.TOTAL_BYTES) / D.TOT_GROOTTE_MB 100, 2), '990.99') "PER",

F.TOTAL_BYTES "FREE(M)",

F.MAX_BYTES "MAX(M)"

FROM (SELECT TABLESPACE_NAME,

ROUND(SUM(BYTES) / (1024 1024), 2) TOTAL_BYTES,

ROUND(MAX(BYTES) / (1024 1024), 2) MAX_BYTES

FROM SYS.DBA_FREE_SPACE

GROUP BY TABLESPACE_NAME) F,

(SELECT DD.TABLESPACE_NAME,

ROUND(SUM(DD.BYTES) / (1024 1024), 2) TOT_GROOTTE_MB

FROM SYS.DBA_DATA_FILES DD

GROUP BY DD.TABLESPACE_NAME) D

WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME

ORDER BY 4 DESC;

That's all for Oracle's article "How to Check Tablespace Usage." Thank you for reading! Hope to share the content to help everyone, more relevant knowledge, welcome to pay attention to the industry information channel!