in fact I see advantages to using private (assuming you are not running
OPS/RAC)
There are times when you might not want all the rollback segments to be
online and available. You have control over this with private rollback
segments. You do not have this control with public rollback segments
Of course, as of 9i, all you need to do is use automatic undo
management and an UNDO tablespace and you don't have to think about
this at all
(yeah right, self-managing databases are just around the corner)
- Tim Gorman <Tim_at_SageLogix.com> wrote:
> This is my understanding of "private" versus "public" rollback
> segments:
> a.. Private RBS can be brought online only via explicit ALTER
> ROLLBACK SEGMENT xxx ONLINE command.
> a.. The "init.ora" parameter ROLLBACK_SEGMENTS is only a list for
> the automatic execution of ALTER ... ONLINE command at database
> instance startup, so it is essentially the same as an explicit ALTER
> ... ONLINE command...
> b.. Public RBS can also be brought online via explicit ALTER ...
> ONLINE or "init.ora" parameter ROLLBACK_SEGMENTS, if you wish...
> b.. Public RBS can also be brought online at instance startup
> according to the formula using the parameters (TRANSACTIONS /
> TRANSACTIONS_PER_ROLLBACK_SEGMENT). In an OPS/RAC environment, this
> allows each instance to select as many public RBS from a "pool" of
> public RBS. The mechanism still works even in non-OPS/RAC
> environments too...
> a.. The use of public RBS is not restricted to OPS/RAC, but it
> doesn't make much sense without it...
> a.. it doesn't make much sense *with* OPS/RAC either, but
> that's just my opinion...
> The upshot is that the only difference between public and private RBS
> is this additional ability to forego the onlining at instance startup
> via the ROLLBACK_SEGMENTS parameter or subsequently via ALTER ...
> ONLINE statements. Instead, at instance startup the simple formula
> using TRANSACTIONS and TRANSACTIONS_PER_ROLLBACK_SEGMENT is used.
> Since these are all static parameters and the difference in
> functionality occurs at only one point-in-time (i.e. instance
> startup), it really is purely a matter of style. I see no advantage
> to using public RBS at all...
>
> Corrections? Comments? Questions?
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, October 17, 2002 10:09 AM
>
>
> >
> >
> > Can't remember where I copied this from, but I believe it came from
> > metalink. I don't have a version associated with it, so things
> might have
> > changed in v9.
> >
> > HTH
> > Barb
> >
> >
> > Public vs. Private Rollback Segments
> > ------------------------------------
> > A common misconception about `Private' rollback segments is that
> they are
> > segments reserved for a particular use or a particular transaction.
> The only
> > difference between Public and Private rollback segments is in
> relation to
> > the Parallel Server Option. A public rollback segment can be
> acquired
> > implicitly by any instance in a parallel server environment. A
> private
> > rollback segment must be explicitly acquired by a particular
> instance using
> > the rollback_segments parameter. If not using OPS, the difference
> between
> > the two is insignificant.
> >
> >
> > > ----------
> > > From: dist cash[SMTP:mccdba_at_hotmail.com]
> > > Reply To: ORACLE-L_at_fatcity.com
> > > Sent: Thursday, October 17, 2002 9:18 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: [Q] Public and private rollback segment?
> > >
> > >
> > >
> > >
> > > We have ORACLE 8.1.7.4 running on NT. My questions are:
> > >
> > > 1. What difference between public rollback segment and private
> segement?
> > >
> > > 2. what is benefit on public segment than private segment?
> > >
> > > 3. does public segment only use on "paraller server (RAC)"?
> > >
> > > Thanks.
> > >
> > >
> > > _________________________________________________________________
> > > Choose an Internet access plan right for you -- try MSN!
> > > http://resourcecenter.msn.com/access/plans/default.asp
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: dist cash
> > > INET: mccdba_at_hotmail.com
> > >
> > > Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> > > San Diego, California -- Mailing list and web hosting
> services
> > >
> ---------------------------------------------------------------------
> > > 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: Baker, Barbara
> > INET: bbaker_at_denvernewspaperagency.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting
> services
> >
> ---------------------------------------------------------------------
> > 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!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Oct 17 2002 - 14:24:04 CDT
