Skip to Main Content
Forums

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 size

apps_db_adminDec 22 2011 — edited Dec 27 2011
Hi,

We have a production database with size 120GB (DB Version 11.1.0.6), And our UNDO Tablespace size is 30GB.

For the past 4 days the UNDO tablespace utilization is more than 85%.

We have disabled the AUTOEXTEND for the UNDO Tablespace.

So the UNDO RETENTION is dynamically calculated by Oracle itself and the value now is

TUNED_UNDORETENTION
-------------------------------------
339183

Please suggest how to fix this issue.

Thanks !
This post has been answered by Helios-GunesEROL on Dec 22 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 24 2012
Added on Dec 22 2011
#general-database-discussions
5 comments
246 views