latch: cache buffers chains and rollback

I had an interesting encounter with latch: cbc contention early this week. During my oncall I received page for Load of 206.81 exceeded threshold of 150. After I logged into server , the server load average was continously increasing and all the top PIDs were of oracle processes. After logging into database, I saw multiple …

Advertisement

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

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$ …