Hi,
Ghassan, first I tried only 2nd issue, it didnot work alone. After doing the
first issue in addition to that, now I am not getting the errors.
Thanks.
derya.
On 9/11/06, Ghassan Salem <salem.ghassan_at_gmail.com> wrote:
>
> Derya,
> what you can do is :
>
> 1. drop old snapshots from the awr (look at
> dbms_workload_repository.drop_snapshot_range)
> 2. modify the capture frequency (or stop the capture if you do not
> use it): look at dbms_workload_repository.modify_snapshot_setting. It allows
> you also to specify the retention period, so that it drops the old ones
> automatically.
>
> rgds
>
> On 9/11/06, Derya Oktay <deryaoktay_at_gmail.com> wrote:
> >
> > 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_HISTORYpartition WRH$_ACTIVE_3099024518_2947 by 128 in tablespace
> > SYSAUX
> > Regards
> >
> >
> > On 9/11/06, Ghassan Salem < salem.ghassan_at_gmail.com> wrote:
> > >
> > > Derya,
> > > can you be a bit more specific? which segment is growing in your
> > > sysaux?
> > >
> > > rgds
> > >
> > >
> > > On 9/11/06, Derya Oktay < deryaoktay_at_gmail.com> 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.2 database 5 months ago. We had RAC running on AIX 5L. Is ther e
> > > > anyone having same problem?
> > > > Any help greatly appreciated. Thanks.
> > > > Derya OKTAY
> > > >
> > >
> > >
> >
>
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 18 2006 - 08:25:28 CDT
