RE: Set transaction does not work

No, but just a select can end up "snapshot too old" (or update/delete because these includes a select).

The updates/deletes of the other transactions may lead to this, because the select can't get a consistent view from rollback segs, when the needed data is overwritten by another transaction. This is mostly a pain of the long running queries when there is lot of other update/delete/insert activities in the db.

Br.
Jorma

> -----Original Message-----
> From: ext Mohammad Rafiq [mailto:rafiq9857_at_hotmail.com]
> Sent: 29 March, 2001 22:07
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Set transaction does not work
>
>
> Under your situation of select only statement there is no use
> of rollback
> segment whether big or small. This error is a result of some
> other long
> running job using that rollback segment. Please advise
> relevant developer
> to check his code doing some delete,update,insert and
> intoduce some commit
> size in his code first. To implement set transaction use
> commit first like
>
> commit;
> set transaction use rollback segment BIG_ROLLBACK;
> then your sql or code
>
> HTH
> Regards
> Rafiq
>
>
>
> Reply-To: ORACLE-L_at_fatcity.com
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Date: Thu, 29 Mar 2001 09:50:55 -0800
>
> RDBMS 7.3.2.3
>
> I am running this under SQLPLUS
>
> set transaction use rollback segment BIG_ROLLBACK
>
> select c1, c2
> from giant_poorly_indexed_table
> where unindexed_colum='****';
>
> exit;
>
> I end up with "snapshot too old" rollback segment RB_07.
>
> Why won't it use the giant rollback segment I created for
> this transaction?
> The
> segment is public and it is online.
>
>
>
>
> > -----Original Message-----
> > From: Brian Wisniewski [SMTP:brian_wisniewski_at_yahoo.com]
> > Sent: Thursday, March 29, 2001 7:45 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Is terminal release of 8.0.x still supported?
> >
> > I checked yesterday and 8.0.6 which is the terminal 8.0.X
> release is
> > still supported on Solaris. Freakin' vendor won't certify their
> > product for anything above 8.0.5 which hasn't been
> supported for nearly
> > a year now. mumble, mumble...
> >
> > - Brian
> >
> > --- Cherie_Machler_at_gelco.com wrote:
> > >
> > > We have some 8.0.4 databases running on Sun Solaris.
> > > I believe that 8.0.4 has been desupported as of December
> 31, 2000.
> > > We are unable to upgrade one of our apps at this time that is
> > > running on an 8.0.4 database.
> > >
> > > Is the terminal release of 8.0.x still supported? If
> yes, what is
> > > that terminal release? Is it 8.0.7? How long before
> that terminal
> > > release will be desupported (if it is currently supported)?
> > >
> > > Thanks,
> > >
> > > Cherie Machler
> > > Gelco Information Network
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > > INET: Cherie_Machler_at_gelco.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing
> > > Lists
> > >
> --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed
> from). You may
> > > also send the HELP command for other information (like
> subscribing).
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Get email at your own domain with Yahoo! Mail.
> > http://personal.mail.yahoo.com/?.refer=text
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Brian Wisniewski
> > INET: brian_wisniewski_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access /
> Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like
> subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: blair_at_pjm.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mohammad Rafiq
> INET: rafiq9857_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jorma.Vuorio_at_nokia.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).