1.查看所表空间大小
SQL>select tablespace_name,sum(bytes)/1024/1024
from dba_data_files
group
by tablespace_name;
TABLESPACE_NAME SUM(BYTES)/1024/1024
------------------------------
--------------------
ZXIN_DATA 2048
ZXUMA_DATA 4096
UNDOTBS1 8192
SYSAUX
512
ZXDBP_156 2048
USERS
512
SYSTEM
512
ZXDBP_166 20480
ZXUMA2_DATA 4096
9 rows
selected.
2.已经空闲的表空间大小
SQL>select tablespace_name,sum(bytes)/1024/1024
from dba_free_space
group
by tablespace_name;
TABLESPACE_NAME SUM(BYTES)/1024/1024
------------------------------
--------------------
ZXIN_DATA 2047.875
ZXUMA_DATA 3504.0625
UNDOTBS1 2890.6875
SYSAUX
332.0625
ZXDBP_156 2030.1875
USERS
511.9375
SYSTEM
172.25
ZXDBP_166 20325.8125
ZXUMA2_DATA 4076.0625
3.查看Oracle表空间大小--已经使用的百分比
select
a.tablespace_name,a.bytes/1024/1024
"Sum
MB",(a.bytes-b.bytes)/1024/1024
"used
MB",b.bytes/1024/1024 "free MB",
round(((a.bytes-b.bytes)/a.bytes)*100,2)
"percent_used"
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
如果觉得《查看oracle所有表空间及大小 查看Oracle数据库表空间大小的方法合集》对你有帮助,请点赞、收藏,并留下你的观点哦!