RBS not using 2005-06-03 - By Onkar N Tiwary
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@(protected)> 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@(protected) [mailto:oracle-l-bounce@(protected)]
> On
> Behalf Of Onkar N Tiwary
> Sent: Friday, June 03, 2005 14:01
> To: oracle-l@(protected)
> 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 (See ora-01555.ora-code.com): 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@(protected)
> onkarnath.tiwary@(protected)
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
Thanks & Regards,
T. Onkar Nath
Ph : +91-9826728111(Cell)
to_onkar@(protected)
onkarnath.tiwary@(protected)
--
http://www.freelists.org/webpage/oracle-l
|
|
