Re: [Q] Public and private rollback segment?

From: <Reginald.W.Bailey_at_jpmorgan.com>
Date: Thu, 17 Oct 2002 08:04:56 -0800
Message-ID: <F001.004EC267.20021017080456@fatcity.com>

Private rollback segments usually are listed in the init.ora file. Public rollback segments are created with the "PUBLIC" parameter and are available to multiple instances that accesses the same database. Private rollback segments are also explicitly acquired when an instance opens a database.

RWB "dist cash" <mccdba_at_hotmail.com>@fatcity.com on 10/17/2002 10:18:55 AM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

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: 
  INET: Reginald.W.Bailey_at_jpmorgan.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:04:56 CDT