Saturday, March 17, 2012

MMON will try to purge old data from SYSAUX

MMON will try to purge old data from SYSAUX

Hello DBA's, specially Karan, Well i just had a strong sweet coffee and feeling good

today I found a very interesting thing in Alert log file that indicating that whenever SYSAUX tablespace becomes full then MMON will try to purge old data from SYSAUX tablespace to make free space for other data.

Please look the contents that I found in Alert Log file :
---------------------------------------------------------------


Tue Jan 17 10:00:03 2012
ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition WRH$_ACTIVE_2503051407_14753 by 128 in tablespace SYSAUX
MMON Flush encountered SYSAUX out of space error(1688).
MMON (emergency) purge of WR snapshots (14690) and older