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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [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 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: [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: Hillman, Alex
INET: [EMAIL PROTECTED]
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: [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).
