RE: private/public rollbacks

From: Hillman, Alex <Alex.Hillman_at_usmint.treas.gov>
Date: Mon, 16 Jul 2001 12:21:12 -0700
Message-ID: <F001.0034B5CB.20010716120042@fatcity.com>

snippet from FM - part of alter rollback segment <name> offline - can be done for privete and public rollback segments.

OFFLINE
Specify OFFLINE to take the rollback segment offline.

If the rollback segment does not contain any information needed to roll back an active transaction, Oracle takes it offline immediately.

If the rollback segment does contain information for active transactions, Oracle makes the rollback segment unavailable for future transactions and takes it offline after all the active transactions are committed or rolled back.

Once the rollback segment is offline, it can be brought online by any instance.

To see whether a rollback segment is online or offline, query the data dictionary view DBA_ROLLBACK_SEGS. Online rollback segments have a STATUS value of IN_USE. Offline rollback segments have a STATUS value of AVAILABLE.

Alex Hillman

-----Original Message-----
Sent: Monday, July 16, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L

Lyuda,

    The chief advantage of private rollback segments is that you can take them
offline if/when needed. A public rollback segment is online always consequently
making it impossible to get out of the way of batch processes or doing any kind
of maintenance on, unless your in restricted access mode.

Dick Goulet

____________________Reply Separator____________________
Author: lhoska_at_calibresys.com
Date:       7/16/2001 10:06 AM

Hi List,
Who can tell me what advantages/disadvantages of having private rollback segments versus public rollback segments? Thank you.

Lyuda Hoska

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: lhoska_at_calibresys.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Hillman, Alex
  INET: Alex.Hillman_at_usmint.treas.gov

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 Mon Jul 16 2001 - 14:21:12 CDT