Re: RBS not using

Onkar

Read Jeremiah Wilton's great paper=20
http://www.speakeasy.org/~jwilton/oracle/snapshot-too-old.html In a nutshell, your transaction is using blocks that were modified by ANOTHER process.

Dennis Williams

On 6/3/05, Onkar N Tiwary <onkarnath.tiwary_at_gmail.com> wrote:
> Hi all,
> I have got one problem. I am running a script in which my first statemen=
t
> is " SET TRANSACTION USE ROLLBACK SEGMENT RBS01;" but the script is throw=
ing
> error as " ora-01555: snapshot too old. Rollback segment rbs02 too small"=
 .
> Now the problem is why its throwing error on RBS02 when I have set my
> transaction to use RBS01? Any comments on this or any suggestion ?
>=20
> --
> Thanks & Regards,
> T. Onkar Nath
> Ph : +91-9826728111(Cell)
> to_onkar_at_yahoo.com
> onkarnath.tiwary_at_gmail.com
>=20
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l