ORA-01562: failed to extend rollback segment number 96
It seemed that some transactions were doing DML, but they failed to proceed because of the full of rollback segments. In such situation, you have several options:
- If you saw the error repeatedly showed in the alert log, you’d be better to add some space to it. Please manually increase the size of said rollback segment in order to allow transactions to extend the segment automatically.
- Killing some of the sessions which were using this rollback segment in order to release the space of rollback segments.
- Let users make the decision. That is, if users were able to respond to the database, they can rollback their transactions or insist on waiting for available space.