Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is using OPTIMAL in RBS ORA-1555 prone?
Thanks to all responders.
I`ve got the picture now.
-- Syltrem http://pages.infinit.net/syltrem (OpenVMS related web site - en français) To reply to myself directly, remove .spammenot from my address "Connor McDonald" <connor_mcdonald_at_yahoo.com> a écrit dans le message de news: 3C72D754.5F8D_at_yahoo.com...Received on Fri Feb 22 2002 - 10:33:31 CST
> 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..."