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: Rollback Segments

Re:RE: Rollback Segments

From: <dgoulet_at_vicr.com>
Date: Wed, 09 May 2001 10:15:43 -0700
Message-ID: <F001.002FE03E.20010509085720@fatcity.com>

Kev,

    A public rollback segment is immediately placed on line after creation and is automatically picked up by the instance at startup. Consequently doing maintenance on them is a real pain in the A&^. Private rollback segments on the other hand have to be listed in your init.ora file to be used by the instance and can be taken off line for maintenance purposes. They are both public assets it's just a matter of how the database treats them. BTW: If you have private RBS's and loose that particular tablespace it's very easy to get the instance back on it's feet again. If their public, you can be in for a pile of fun!!!

Dick Goulet

____________________Reply Separator____________________
Author: "Kevin Kostyszyn" <kevin_at_dulcian.com>
Date:       5/9/2001 7:20 AM

Hi all,
        This brings me to a stupid question then.  What is the true difference
between a public and a private rollback segment? Because if I just think about it like a normal human being I would think that if a user made a Private rollback segment then only that user could use it, but of course I know that can't be the case.
Kev

-----Original Message-----
Sent: Wednesday, May 09, 2001 10:26 AM
To: Multiple recipients of list ORACLE-L

Nixon,

While SET TRANSACTION can be used to assign a rollback segment to a transaction, it cannot be assigned exclusively to that transaction as you have found.

The ability to assign a rollback segment to a transaction and make it read-only for all others is something I've wanted myself for many years, and I know it's been on the official 'wish list' of requested changes by IOUG for some time.

Maybe 9i? Anyone know?

Jared

On Wednesday 09 May 2001 01:40, Nixon_Villanueva_at_manulife.com wrote:
> Hi All,
>
> Here is my environment;
>
> NT v4
> Db Oracle Workgroup v8.1.6
>
> Rollback Segments
> SEGMENT_NAME OWNER TABLESPACE_NAME
> ------------------------------ ------ ------------------------------
> SYSTEM SYS SYSTEM
> RBS0 PUBLIC RBS
> RBS_P1 SYS RBS
> RBS_P2 SYS RBS
> RBS_P3 SYS RBS
> RBS_P4 SYS RBS
> RBS_P5 SYS RBS
>
>
> Is it possible to assign one public rollback segment explicitly to one
> particular transaction? I tried using SET TRANSACTION USE ROLLBACK SEGMENT
> but other users I found out can still use it. So, I guess the best
> alternative is to set that RB segment to OFFLINE after using and set
ONLINE
> before executing the SET TRANSACTION ... Do you know how it can be done
> inside Forms?
>
> Thanks in advance!

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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: Kevin Kostyszyn
  INET: kevin_at_dulcian.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Wed May 09 2001 - 12:15:43 CDT

Original text of this message

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