Question

Oracle: How can I use a large rollback segment ( rblarge )to avoid the snapshot too old error ?

Answer 1

You can use the following command

set transaction use rollback segment rblarge;

This has to be the first statement of the transaction and you need to reissue this statement whenever you end the transaction, i.e, most of us forget to re issue the command after a commit or rollback.