Conflicting tablespace space
Hi:
I am running OEM out of the box with most of its default values. I am receiving a daily em critical alert that my sysaux tablespace is 97%full (below):
Name= prod.pnc.edu
Type= Database Instance
Host= orcprod.pnc.edu
Metric= Tablespace Space Used (%)
KEY_VALUE= SYSAUX
Timestamp= Feb 24, 2010 7:57:23 PM CST
Severity= Critical
Message= Tablespace [SYSAUX] is [97 percent ] full
Rule Name= Database Availability and Critical States
Rule Owner= SYSMAN
So I go and check directly in the database to reconfirm and do a couple of checks:
select TABLESPACE_NAME , sum(bytes/1024/1024) from sys.dba_free_space
2 where tablespace_name = 'SYSAUX'
I am running OEM out of the box with most of its default values. I am receiving a daily em critical alert that my sysaux tablespace is 97%full (below):
Name= prod.pnc.edu
Type= Database Instance
Host= orcprod.pnc.edu
Metric= Tablespace Space Used (%)
KEY_VALUE= SYSAUX
Timestamp= Feb 24, 2010 7:57:23 PM CST
Severity= Critical
Message= Tablespace [SYSAUX] is [97 percent ] full
Rule Name= Database Availability and Critical States
Rule Owner= SYSMAN
So I go and check directly in the database to reconfirm and do a couple of checks:
select TABLESPACE_NAME , sum(bytes/1024/1024) from sys.dba_free_space
2 where tablespace_name = 'SYSAUX'
0