RE: Rollback datafile size

Daniel,

Thank you again. That clears it up even more. I'll wait for a quiet time and then proceed.

Mike

-----Original Message-----
Sent: Monday, December 22, 2003 2:19 PM
To: Multiple recipients of list ORACLE-L

Mike,

When an RBS is taken offline, the undo information is not transfered to another
segment, hence the need to perform these actions at a quiet time. When an rbs
is taken offline, all transactions currently using the rbs are allowed to complete (either commit or rollback). As these transactions are processing, the
status of the segment is 'Pending Offline'. Once the tx is complete, the status
will change to 'Offline'. If a query is running and needs undo entries from an
offline (including pending) rbs, it will fail with a 1555.

Daniel

Michael Milligan wrote:

> Daniel,
>
> Thank-you very much for your clear answer. Very helpful. When a RBS is
taken
> off-line, does it transfer the rollback information to another segment?
>
> Thanks,
>
> Mike

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel Fink
  INET: Daniel.Fink_at_Sun.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).


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by replying
to this message and delete this e-mail immediately.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Michael Milligan
  INET: Michael.Milligan_at_ingenix.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).