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 :-)
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