No, that isn't it. :)
"Sherman, Paul R." <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/17/2002 12:37 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: RE: [Q] Public and private rollback segment?
Jared,
Ah... but, no one had an opportunity to access the segment that you
created.
I'm prob. wrong, but I seem to remember that at one time (the mists) once
the rollback seg was accessed, you could not just 'off it'. Could be I'm
thinking of something else.
Thank you,
Paul Sherman
DBA Elcom, Inc.
voice - 781-501-4143 (direct #)
fax - 781-278-8341 (secure)
email - [EMAIL PROTECTED]
-----Original Message-----
Sent: Thursday, October 17, 2002 3:14 PM
To: Multiple recipients of list ORACLE-L
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sherman, Paul R.
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).
