Begining Rollback-to-Undo conversion research

[TimHall]

Tim, did you author that article ?

"Hope this helps. Regards Tim..."

thanks

I am wondering about how sized rollback segments map over to the size of undo segments.

..off to tahiti..

Yes I did ;-)

I would start by making the UNDO tablespace about that same size as your current total redo size. Of course, if you want to retain the data for longer you are going to need a bit more space.

Once you are up and running you can use the undo advisor to check how your undo is performing, and what sort of retention time you can expect under typical load.

Suppress errors? Yes, unless you want to identify code that tries to use a specific RBS.

Cheers

Tim...