[Q] undo tablespace did not release space??
- From: dba1 mcc <mccdba1@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 26 Mar 2004 08:47:43 -0800 (PST)
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
- » [Q] undo tablespace did not release space??
