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

From: <Jared.Still_at_radisys.com>
Date: Thu, 17 Oct 2002 11:13:37 -0800
Message-ID: <F001.004EC926.20021017111337@fatcity.com>

No, I don't think so.

11:08:27 rsysdevdb.radisys.com - jkstill_at_dv01 SQL> create tablespace puglic rollback segment jks tablespace rbs;

Rollback segment created.

11:08:47 rsysdevdb.radisys.com - jkstill_at_dv01 SQL> alter rollback segment jks online;

Rollback segment altered.

11:08:55 rsysdevdb.radisys.com - jkstill_at_dv01 SQL> c/on/off   1* alter rollback segment jks offline
11:08:58 rsysdevdb.radisys.com - jkstill_at_dv01 SQL> /

Rollback segment altered.

11:09:00 rsysdevdb.radisys.com - jkstill_at_dv01 SQL> drop public rollback segment jks;

Rollback segment dropped.

11:09:08 rsysdevdb.radisys.com - jkstill_at_dv01 SQL>

dgoulet_at_vicr.com
Sent by: root_at_fatcity.com
 10/17/2002 09:46 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Re:RE: [Q] Public and private rollback segment?

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



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jared.Still_at_radisys.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:13:37 CDT