I just recently converted a single instance from auto to manual due to
an alert from Siebel when trying to do an upgrade. While they claimed
there process only works with a traditional large single rollback
segment, it still failed with ORA-01555 (See ORA-01555.ora-code.com), which I predicted would happen.
In answer to your question about performance, we 've implemented AUM on
over 20 production instances with a marked decrease in these types of
errors, and anecdotally improved performance.
While I cannot help you with your specific RAC question, we 've had so
much more success with undo management over rollback segments, I have a
hard time believing you really need to revert back. I only did so to
placate our consultant, who showed me a document from a vendor (now
since contradicted by yet other documents from the same vendor!!!),
stating the process required using rollbacks.
If I had a nickel for every time this happened....
Michael Fontana
Sr. DBA
NTT/Verio
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
