详情:
本实例主要针对Oracle表空间爆满问题处理方法做个步骤分享。
一、告警信息
收到zabbix告警信息,表空间 SYSAUX 使用率>95%%,系统表空间sysaux使用率超过了95%。
二、处理步骤
1.登录具体数据库做相应的数据库空间使用率查询
set line 200;
set pagesize 20000;
set feedback off;
col tablespace_name for a20;
col c_free_percent for a12;
col c_used_percent for a12;
col m_free_percent for a12;
col m_USED_PERCENT for a12;
select
d.tablespace_name,round(d.MB_current_Bytes,2)
Curr_Size_MB,round(f.free_mb_bytes,2)
Free_Szie_MB,round(d.MB_maxbytes,2)
MAX_Size_MB,round((f.free_mb_bytes/d.MB_current_Bytes)*100,2)
c_free_percent,round((d.MB_current_Bytes-f.free_mb_bytes)/d.MB_current_Bytes,4)*100
|| '%'
c_used_percent,round(((d.MB_maxbytes-d.MB_current_Bytes+f.free_mb_bytes)/d.MB_maxbytes)*100,2)
m_free_percent,round((d.MB_current_Bytes-f.free_mb_bytes)/d.MB_maxbytes,4)*100
|| '%' m_used_percent
from (select
tablespace_name,sum(bytes/1024/1024)
MB_cur