Re: Rollback seg for big job

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).