| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: undo segments online causing performance problems.
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. Received on Fri Dec 30 2005 - 15:05:22 CST
 |
 |