Home » RDBMS Server » Server Administration » Undo space
Undo space [message #238680] Fri, 18 May 2007 23:56 Go to next message
gajini
Messages: 259
Registered: January 2006
Senior Member
Hi,

My undo tablespace is almost full. How to manually free the unused undo space in Automatic undo management mode?
Please let me know the step,how to do this.

Thanks..
Re: Undo space [message #238686 is a reply to message #238680] Sat, 19 May 2007 00:38 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't have or need to manage space in your undo tablespace. Oracle do it for you.
It will release space when it needs it.
Undo tablespace is ALWAYS almost or completly full after a while, this is the normal behaviour.

Regards
Michel
Previous Topic: faq
Next Topic: can't offline
Goto Forum:
  


Current Time: Fri Dec 02 16:34:49 CST 2016

Total time taken to generate the page: 0.22691 seconds