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: Set transaction does not work

RE: Set transaction does not work

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Thu, 29 Mar 2001 11:00:16 -0800
Message-ID: <F001.002DBE1C.20010329104602@fatcity.com>

What would a 'private rollback segment' be? Anyway, it isn't working not because of the select statement but because of the rollback segments used by transactions modifying the table ('giant_poorly_indexed_table'). Those transactions need to go into a separate rollback segment so that the select in question can reconstruct the read-consistent version it needs.

-----Original Message-----
Sent: Thursday, March 29, 2001 1:12 PM
To: Multiple recipients of list ORACLE-L

I think the big rollback segment needs to be private.

>>> blair_at_pjm.com 03/29/01 12:50PM >>>
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Sawmiller
  INET: sawmillert_at_state.mi.us

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: Gogala, Mladen
  INET: MGogala_at_oxhp.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).
Received on Thu Mar 29 2001 - 13:00:16 CST

Original text of this message

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