Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RBS not using
you indeed don't understand how things work; you typically use *all* rollback segments to produce read consistency, depending on who changed the block. the only thing you achieve with SET TRANSACTION is that if you start making changes yourself, you will write undo information to the rollback segment of your choice.
kind regards,
Lex.
Lex/Dennis,
Thanx for the suggestion but my main query is why my transaction is not using
RBS01 when I have set the same for the current transaction?? No doubt u guys are
absolutely right but when I am setting the transaction to use
RBS01 then it should use that only and not the other rollback segment(if I am
not wrong).
On 6/3/05, Lex de Haan <lex.de.haan_at_naturaljoin.nl> wrote:
>
>
> the error is unrelated to the SET TRANSACTION statement. the error
> simply means that Oracle is not able to provide a read-consistent
> image of the data you access in the script, probably caused by *other*
> transactions simultaneously running on the same database, making
> changes to the database, and committing those changes. Those *other*
> transactions are apparently using rollback segment RBS02, and
> apparently that rollback segment is quite small -- so it gets
> overwritten in a cyclic way. You probably have a heavy, long-running
> query in your script?
>
> hope this helps,
> kind regards,
>
> Lex.
>
> ------------------------------------------------------------------
> Steve Adams Seminar http://www.naturaljoin.nl/events/seminars.html
> ------------------------------------------------------------------
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]
> On
> Behalf Of Onkar N Tiwary
> Sent: Friday, June 03, 2005 14:01
> To: oracle-l_at_freelists.org
> Subject: RBS not using
>
> Hi all,
> I have got one problem. I am running a script in which my first
> statement is "
> SET TRANSACTION USE ROLLBACK SEGMENT RBS01;" but the script is
> throwing 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 ?
>
> --
> Thanks & Regards,
> T. Onkar Nath
> Ph : +91-9826728111(Cell)
> to_onkar_at_yahoo.com
> onkarnath.tiwary_at_gmail.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Thanks & Regards, T. Onkar Nath Ph : +91-9826728111(Cell) to_onkar_at_yahoo.com onkarnath.tiwary_at_gmail.com -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 06 2005 - 03:19:47 CDT