Re: RBS not using
- From: Jared Still <jkstill@xxxxxxxxx>
- To: lex.de.haan@xxxxxxxxxxxxxx
- Date: Fri, 10 Jun 2005 09:05:20 -0700
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 <lex.de.haan@xxxxxxxxxxxxxx> 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 http://www.naturaljoin.nl/events/seminars.html
> ------------------------------------------------------------------
> -----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).
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
