Re: Delayed block cleanout and changing automatic undo tablespace

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Tue, 20 Jul 2004 03:12:42 -0700 (PDT)
Message-ID: <20040720101242.94610.qmail@web41504.mail.yahoo.com>

Tim:

FTS or exporting the table to /dev/null does not necessarily do a block clean out. If the blocks are already in the cache as a CR buffer (or an current buffer with undo buffers are in cache) it can be used to construct the block images and no clean outs are necessary.

You can offline the undo segments and drop the undo tablespace if there are no active transactions using that segment. Active transactions using that undo segments can be found from (KTUXE) which is exposed as V$transaction.

The other alternative is to wait for some (!) more time and once all the transactions vacates the old undo tablespace, you can safely drop the tablespace.

Have a nice day !!

Best Regards,
K Gopalakrishnan,
Co-Author: Oracle Wait Interface: Oracle Press 2004. http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Tue Jul 20 2004 - 05:09:17 CDT