ORA-01628: max # extents (32765) reached for rollback segment _SYSSMUxxx

Posted 3 CommentsPosted in 11gR2, ORA Error, undo

Recently I came across “ORA-01628: max # extents (32765)” error. The database had resumable_timeout parameter set I received page for a session in resumable state. Looking into the alert log showed statement in resumable session ‘User USER_E3(375), Session 9028, Instance 1’ was suspended due to ORA-01628: max # extents (32765) reached for rollback segment _SYSSMU375_247595031$ […]