Home > Oracle in general > Oracle 11g Release 2 – AWR emergency purging

Oracle 11g Release 2 – AWR emergency purging

During the night my SYSAUX tablespace filled up to the maximum allowed size so AWR could not save it´s data. In the database alert.log i found the following:

Tue Oct 06 02:02:38 2009
ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY
  partition WRH$_ACTIVE_270645195_176 by 8 in tablespace SYSAUX
MMON Flush encountered SYSAUX out of space error(1688).
MMON (emergency) purge of WR snapshots (105) and older

It seems if there is not enough space available for saving AWR data AWR will automatically delete the oldest snapshots to free up space. Nice feature :-)

Categories: Oracle in general Tags:
  1. Marc Shaw
    October 15th, 2009 at 22:33 | #1

    Hey, I read a lot of blogs on a daily basis and for the most part, people lack substance but, I just wanted to make a quick comment to say GREAT blog!…..I”ll be checking in on a regularly now….Keep up the good work! :)

    – Marc Shaw

  1. No trackbacks yet.