Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: [Q] Public and private rollback segment?

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

From: <Jared.Still_at_radisys.com>
Date: Thu, 17 Oct 2002 12:59:41 -0800
Message-ID: <F001.004ECBEF.20021017125941@fatcity.com> 





No, that isn't it.  :)







"Sherman, Paul R." <PSherman_at_elcom.com>


Sent by: root_at_fatcity.com


 10/17/2002 12:37 PM


 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?






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 - psherman_at_elcom.com




-----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_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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Paul R.
  INET: PSherman_at_elcom.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 - 15:59:41 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US