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

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Mon, 18 Feb 2002 18:17:26 GMT
Message-ID: <3C714542.22B587A0@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
Received on Mon Feb 18 2002 - 12:17:26 CST