Oracle11g单机表空间扩容
Zabbix提示一台服务器Tablespace SYSTEM size is 74.92 GB (>0.99*68.88 GB),需要扩容system表空间
查询表空间利用率
set linesize 200 set pages 2000 col TABLESPACENAME for a30 select substr(a.TABLESPACE_NAME,1,30) TablespaceName, sum(a.bytes/1024/1024) as "Totle_size(M)", sum(nvl(b.free_space1/1024/1024,0)) as "Free_space(M)", sum(a.bytes/1024/1024)-sum(nvl(b.free_space1/1024/1024,0)) as "Used_space(M)", round((sum(a.bytes/1024/1024)-sum(nvl(b.free_space1/1024/1024,0))) *100/sum(a.bytes/1024/1024),2) as "Used_percent%" from dba_data_files a,(select sum(nvl(bytes,0)) free_space1,file_id from dba_free_space group by file_id) b where a.file_id = b.file_id(+) group by a.TABLESPACE_NAME order by "Used_percent%";
查看数据文件
set linesize 300 set pagesize 500 col file_name format a55 col tablespace_name format a13 select tablespace_name,file_id,status,bytes/1024/1024 FileSizeM,file_name from dba_data_files order by tablespace_name;
查看分区空间
!df -Th
表空间扩容
alter tablespace system add datafile '/oradata/etlcdr/system04.dbf' size 31G;
查看表空间现在大小
本站所有文章均可随意转载,转载时请保留原文链接及作者。