Database Administration (MOSC)

MOSC Banner

Conflicting tablespace space

edited Mar 1, 2010 6:17AM in Database Administration (MOSC) 5 commentsAnswered
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'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center