Oracle cursor for updating every row in same table
if you are in extent N and N 1 is being used still (or with AUM N 1 contains information that cannot yet be overwritten because of the undo_retention), we'll allocate a new extent and stick it in there.
If your database does lots of little transactions, the RBS will never grow on their own. Now, someone needs to run a query that will take 5 minutes. What will be the condition at which the rollback segment wraps to extent 1.
I've been dealing with this error off and on for the last 3 years and I just wanted to verify that my understanding of its cause is accurate.
Cause 1) There is only one user logged into the database.
I like have a good understanding of TX extending vs.
RBS extending Sceanrio 1: RBS extent has one block free.