一、表空间的使用情况
1、数据表空间
1、数据表空间
查看数据表空间已经已分配磁盘的空间的使用情况
---------------------- 查询语句 ----------------------
SELECT
A.TABLESPACE_NAME, A.BYTES/1024/1024 "DISK_SIZE(MB)", (A.BYTES-B.BYTES)/1024/1024 "USED_SIZE(MB)",
B.BYTES/1024/1024 "FREE_SIZE(MB)", ROUND(((A.BYTES-B.BYTES)/A.BYTES)*100,2) "USED_RATE(%)"
FROM
(SELECT TABLESPACE_NAME,SUM(BYTES) BYTES FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME) A,
(SELECT TABLESPACE_NAME,SUM(BYTES) BYTES, MAX(BYTES) LARGEST FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) B
WHERE
A.TABLESPACE_NAME=B.TABLESPACE_NAME;
---------------------- 查询结果 ----------------------
TABLESPACE_NAME DISK_SIZE(MB) USED_SIZE(MB) FREE_SIZE(MB) USED_RATE(%)
------------------------------ ------------- ------------- ------------- ------------
SYSTEM 9452 741.1875 8710.8125 7.84
AUDIT 204800 179401 25399 87.6
USERS 11024 3020.1875 8003.8125 27.4
UNDOTBS2 94207.9844 1888.04688 92319.9375