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 sizing: reuse unexpired and expired extents

user13322577Dec 3 2017 — edited Dec 7 2017

Dear All,

How can I deal with Unexpired undo extents, and how can reuse the space ?

Because since one week I'm observing the Undo Tablespace is growing.

Need your suggestion.

I found the below link related to this issue, kindly review and let me know if this is the correct solution ?

https://urisnotaword.wordpress.com/2012/01/06/undo-unexpired-extents-not-released/

FYI, my database is 12.2 pluggable

Regards

Amer

This post has been answered by EdStevens on Dec 7 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 4 2018

Added on Dec 3 2017

#general-database-discussions

14 comments

3,142 views