| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Rollback seg for big job
Joan,
yikes! I think I'm glad I don't do this.
Rachel
>From: Joan Hsieh <joan.hsieh_at_tufts.edu>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Rollback seg for big job
>Date: Fri, 27 Jul 2001 10:21:04 -0800
>
>Rachel,
>
>we are 8.16. We tried on line a bigrolbk, set tran on this rollback and
>took it offline. Guess what? the job was killed also. Oracle support
>said this is a bug, should be fixed 8.17.
>
>Joan
>
>Rachel Carmichael wrote:
> >
> > well...... you could sort of help to guarantee that no one else uses it.
> >
> > First, bring it online, do a set transaction to use that rollback
>segment,
> > then (in another session), take that rollback segment offline.
> >
> > since you are already using it, it doesn't REALLY go offline (until your
> > transaction ends) but no one else will be assigned to it either.
> >
> > Sneaky.
> >
> > Rachel
> >
> > >From: "Jon Walthour" <jonw_at_fuse.net>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >Subject: RE: Rollback seg for big job
> > >Date: Fri, 27 Jul 2001 04:51:09 -0800
> > >
> > >
> > >
> > >Prasad:
> > >
> > >As far as I know (and listers please correct me if I'm wrong)
> > >you can't single out the rollback segment you are using for that
> > >big transaction EXCLUSIVELY. In other words, since the rbs is
> > >still online and available, there is still the potential that
> > >another transaction could use that rbs as well. However, if you're
> > >running it at night, wouldn't your activity level be lower and
> > >thus the odds of getting another transaction in the same rbs
> > >be much lower as well?
> > >
> > >Just my 2 cents.
> > >
> > >Jon Walthour
> > >
> > > >--- Original Message ---
> > > >From: prasad maganti <prasadm_g_at_yahoo.com>
> > > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > >Date: 7/27/01 7:16:11 AM
> > > >
> > >
> > > >Hi dba's
> > > >
> > > >can anybody clarify my doubt reg. RBS.
> > > >
> > > >i need to run a very big job in night times.
> > > >
> > > >so , i have to create a very bigh rollback segment
> > > >purely intended for that job.
> > > >
> > > >so i will set at sql
> > > >
> > > >set trnx use rollback seg..
> > > >
> > > >my doubt is whether this rollback segment stores the
> > > >rollback of my job or will it allow any other rollback
> > > >of the database (that is not part of my job)
> > > >
> > > >prasad.
> > > >
> > > >__________________________________________________
> > > >Do You Yahoo!?
> > > >Make international calls for as low as $.04/minute with Yahoo!
> > >Messenger
> > > >http://phonecard.yahoo.com/
> > > >--
> > > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > >--
> > > >Author: prasad maganti
> > > > INET: prasadm_g_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: Jon Walthour
> > > INET: jonw_at_fuse.net
> > >
> > >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/intl.asp
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> > INET: carmichr_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: Joan Hsieh
> INET: joan.hsieh_at_tufts.edu
>
>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: Rachel Carmichael INET: carmichr_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).Received on Fri Jul 27 2001 - 14:10:00 CDT
 |
 |