Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Undo Tablespace Full.

582655Jun 12 2007 — edited Mar 20 2008
Hello,

The size of my UNDOTS is 6 GB and undo_retention=21600.
After last application upgrade, we the size of UNDOTS are full and we can't fixit and it create a problem, I open a TAR within Oracle and after two days they don't propose any solution.

Is there any possibility (an Oracle view) that we can see all transaction inside the UDOTS?

For you information, even I increase the size to 9 GB and I reduce the undo_retention=14400, the result are the same full UNDOTS.

Thanks for your suggestion and proposition, it's in production

Regards,


Message was edited by:
user579652

Message was edited by:
user579652
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 17 2008
Added on Jun 12 2007
12 comments
24,405 views