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

941070Jun 6 2012 — edited Jun 6 2012

i am in a big trouble.

At a time my 20 GB undo tablespace was full. So i increased the tablespace size upto 48 GB. Then i saw 45 GB was used. Then i changed undo_retention=60. After that am seeing that 48 GB is full. so can anyone plz help me about.

1) why it's happened?
2) Here what is the effect of undo_retention=60
3) How to resolve?

Plz help. Thanx in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 4 2012

Added on Jun 6 2012

#11g, #database, #dba, #general-database-discussions

15 comments

1,359 views