Hi Ghassan, For instance I am getting below error messages, there also exists other segments:
ORA-1688: unable to extend table SYS.WRH$_SEG_STAT partition WRH$_SEG_ST_3099024518_2898 by 128 in tablespace SYSAUX
ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition WRH$_ACTIVE_3099024518_2947 by 128 in tablespace SYSAUX Regards
Derya, can you be a bit more specific? which segment is growing in your sysaux?
On 9/11/06, Derya Oktay < deryaoktay@xxxxxxxxx> wrote: > > Hi All, > I am recently getting ORA-1688 errors in alert.log. This error is dealt > with SYSAUX tablespace and it is happenin again and again everyday. Adding > datafile does not work either. We had upgraded to 10g R1 from 9.2database 5 months ago. We had RAC running on AIX 5L. Is ther e anyone having > same problem? > Any help greatly appreciated. Thanks. > Derya OKTAY >