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: dropping Undo Tablespace

RE: dropping Undo Tablespace

From: Ted Coyle <oracle-l_at_webthere.com>
Date: Thu, 31 May 2007 16:00:53 -0400
Message-ID: <003001c7a3be$658f43b0$4621a8c0@medecision.com>

 

The rollback may be huge and it might take longer than waiting for it to complete. Just a thought.

Safe is relative. I donít think anyone can answer if it is safe to kill long running on your system from the app perspective, but I think it is Oracle/technically safe.  

I use the same undo reduction process in production warehouses, but Iíve never done by killing sessions.

. The only option i see here is to kill the session (22,16,34), which will offline all the undo segments and then drop the first undo tablespace. This is a production box, so just wanted to confirm with you. Is it safe to go ahead and kill the session? is there any other work around in this case for dropping the first undo tablespace. ď

Ted

No virus found in this outgoing message. Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.8.4/825 - Release Date: 5/30/2007 3:03 PM  

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 31 2007 - 15:00:53 CDT

Original text of this message

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