Query the spatial conditions of TableSpace

xiaoxiao2021-03-05  25

SELECT / * Ordered USE_NL (A b) * / b.tablespace_name,

Trunc (SUM (B.BYTES / 1024/1024), 2) "Free (m)",

Trunc (SUM (A.BYTES / 1024/1024) -SUM (B.BYTES / 1024/1024), 2) "Used (M)",

Trunc (SUM (A.BYTES / 1024/1024), 2) "All (m)"

From DBA_DATA_FILES A

Join DBA_FREE_SPACE B on (a.file_id = b.file_id)

Group by b.tablespace_name;

转载请注明原文地址:https://www.9cbs.com/read-34782.html

New Post(0)