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

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

>