Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RBS not using

Re: RBS not using

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Fri, 3 Jun 2005 08:55:13 -0400
Message-ID: <BAY103-DAV422EB045EF3ACE129593BA6070@phx.gbl>


Are you doing this in pl/sql?
alter session
then
cursor loop
dml here on your cursor
end loop
----- Original Message -----
From: "Onkar N Tiwary" <onkarnath.tiwary_at_gmail.com> To: "Lex de Haan" <lex.de.haan_at_naturaljoin.nl> Cc: <oracle-l_at_freelists.org>
Sent: Friday, June 03, 2005 8:50 AM
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).
>
> 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-l
Received on Fri Jun 03 2005 - 09:01:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US