Tag Archives: ORA-1688

ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition WRH$_ACTIVE_3395507964_562

Posted by on July 19, 2012 1 comment

Problem:

Checked alert log file  and saw the following errors:

ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition 
WRH$_ACTIVE_3395507964_562 by 128 in                 tablespace SYSAUX 
MMON Flush encountered SYSAUX out of space error(1688).
MMON (emergency) purge of WR snapshots (546) and older
ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition 
WRH$_ACTIVE_3395507964_562 by 128 in                 tablespace SYSAUX 
MMON Flush encountered SYSAUX out of space error(1688).
MMON (emergency) purge - nothing to purge, pgsid=0.

Solution:

Add a new datafile to the SYSAUX tablespace.

Read more »