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;
查看表空间现在大小
更新日期: 2019年07月30日
文章标签: Oracle
文章链接: https://www.vos.cn/db/341.html
版权说明:如非注明,本站文章均为vOS原创,转载请注明出处和附带本文链接。
文章标签: Oracle
文章链接: https://www.vos.cn/db/341.html
版权说明:如非注明,本站文章均为vOS原创,转载请注明出处和附带本文链接。