RE: [Q] undo tablespace did not release space??

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Fri, 26 Mar 2004 11:50:40 -0500
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF03B453C8@bosmail00.bos.il.pqe>

Why should it 'release' space? To promote ORA-1555s?

-----Original Message-----

From: dba1 mcc [mailto:mccdba1_at_yahoo.com] Sent: Friday, March 26, 2004 11:48 AM
To: oracle-l_at_freelists.org
Subject: [Q] undo tablespace did not release space??

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


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

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

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:47:17 CST