top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+2 votes
posted Mar 4, 2015 by Vidhya Sagar

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes
Best answer

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.

answer Mar 4, 2015 by Manikandan J
Similar Questions
+2 votes

Below is the one of the interview question which was held by Oracle

If a transaction is very large, and the rollback segment is not able to hold the rollback information, then will the transaction span across different rollback segments or will it terminate?

0 votes

Why should I not commit after every record when updating a large table Committing after every record does not hurt but its much efficient to commit after a batch of records like 5000 - 7000.