Re: undo segments online causing performance problems.

From: zhu chao <zhuchao@xxxxxxxxx>
To: sjaffarhussain@xxxxxxxxx
Date: Fri, 30 Dec 2005 22:05:22 +0800

As a production DBA, my first thought would :
How do I fix it before Oracle give me a solution after 3+ weeks(typical
response time from oracle).
And the answer I think is: revert back to old rollback segment.
Say, online 30 rollback segment with proper size and keep then online. The
old rollback segment works best for big/busy/frequent change database, and
the AUM works best for small/stable database, I think.

That's it.

Follow-Ups:

Re: undo segments online causing performance problems.
From: sol beach

References:
- undo segments online causing performance problems.
  - From: The Human Fly

Re: undo segments online causing performance problems.

Other related posts: