Re:RE: [Q] Public and private rollback segment?

From: <dgoulet_at_vicr.com>
Date: Thu, 17 Oct 2002 08:46:43 -0800
Message-ID: <F001.004EC352.20021017084643@fatcity.com>

Except in the case of maintenance on rollback segments. You can take a private segment offline at anytime, whereas a public one has to be done with the database unmounted.

Dick Goulet

____________________Reply Separator____________________
Author: "Baker; Barbara" <bbaker_at_denvernewspaperagency.com>
Date:       10/17/2002 8: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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.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 - 11:46:43 CDT