Re: Is using OPTIMAL in RBS ORA-1555 prone?

Syltrem wrote:
>
> But then if I don't I'll eventually get an ORA-1650 unable to extend
> rollback segment
>
> I'll have to manually shrink my rollback segments, won't I?
> I just can't let them grow forever...
>
> What is your approach with this?
>
> Thanks
> --
>
> Syltrem
> http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
> To reply to myself directly, remove .spammenot from my address
>
> "damorgan" <dan.morgan_at_ci.seattle.wa.us> a écrit dans le message de news:
> 3C714542.22B587A0_at_ci.seattle.wa.us...
> > Yes. And you are also more likely to generate needless overhead. It is a
> syntax
> > I never use.
> >
> > Daniel Morgan
> >
> >
> >
> > Syltrem wrote:
> >
> > > If using OPTIMAL setting in the rollback segments, am I more likely to
> have
> > > ORA-1555 snapshot too old?
> > >
> > > That is, Oracle will shrink the rollback segment at the start af any new
> > > transaction, so it may thus drop information required by that other
> > > long-running process.
> > >
> > > Even so, you can never tell when a rbs extent will be reused so how can
> you
> > > make 100% sure you will not get this error? Users get it every couple of
> > > weeks and I can't do an alter session use rollback segment xxxx in this
> > > application.
> > >
> > > Any suggestions appreciated.
> > >
> > > --
> > >
> > > Syltrem
> > > http://pages.infinit.net/syltrem (OpenVMS related web site - en
> français)
> > > To reply to myself directly, remove .spammenot from my address
> >

A simple alternative is to shrink them nightly before backups (or some other quiet time)

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."