Re: RBS not using

I recall that the first time I saw ORA-1555 I did not understand
how things worked.
My complaint to Oracle was that I was not using snapshots. :)

The terminology in the error message is less than straightforward.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

On 6/3/05, Lex de Haan <> wrote:
> 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.
> ------------------------------------------------------------------
> Steve Adams Seminar
> ------------------------------------------------------------------
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 
> On
> Behalf Of Onkar N Tiwary
> Sent: Friday, June 03, 2005 14:50
> To: Lex de Haan
> Cc: oracle-l@xxxxxxxxxxxxx
> Subject: Re: RBS not using
> 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).


Other related posts: