No, I don't think so.
11:08:27 rsysdevdb.radisys.com - jkstill@dv01 SQL> create tablespace
puglic rollback segment jks tablespace rbs;
Rollback segment created.
11:08:47 rsysdevdb.radisys.com - jkstill@dv01 SQL> alter rollback segment
jks online;
Rollback segment altered.
11:08:55 rsysdevdb.radisys.com - jkstill@dv01 SQL> c/on/off
1* alter rollback segment jks offline
11:08:58 rsysdevdb.radisys.com - jkstill@dv01 SQL> /
Rollback segment altered.
11:09:00 rsysdevdb.radisys.com - jkstill@dv01 SQL> drop public rollback
segment jks;
Rollback segment dropped.
11:09:08 rsysdevdb.radisys.com - jkstill@dv01 SQL>
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/17/2002 09:46 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
