[Q] undo tablespace did not release space??

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Fri, 26 Mar 2004 08:47:43 -0800 (PST)
Message-ID: <20040326164743.29870.qmail@web60808.mail.yahoo.com>

We have ORACLE 9ir2 running on LINUX server. I check Tablespace and found undo tablespace almost full for long time. It did NOT release space. The undo tablespace setup are undo_management=AUTO undo_retention=900. Does anyone know why it don't release space?

Thanks.

TABLESPACE_NAME FILESIZE BYTES_ALLOCATED BYTES_FREE
------------------------- ---------- ---------------

---

SYSTEM                           220          166.75  
 53.1875
TOOLS                            190           110.5  
 79.4375
UNDO_TS                          550      549.671875  
   .1875
USERS                            500          450.25  

  49.625

---

Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html

---

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 Fri Mar 26 2004 - 10:44:16 CST