Oracle Database Discussions

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

I got this error when I tried to shut down the system

SQL> shutdown immediate
ORA-00604: error occurred at recursive SQL level 1
ORA-01628: max # extents (32765) reached for rollback segment _SYSSMU10$

But then the shutdown never completes

SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01089: immediate shutdown in progress - no operations are permitted

Then I have to do a shutdown abort

Then when I start up
I get the same

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

Here is some information, please suggest what I can do and also any reason why this happened in the first place?

SQL> show parameter undo

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 0
undo_tablespace string undo


select sum(blocks),sum(extents),segment_name from DBA_SEGMENTS where tablespace_name = 'UNDO' group by segment_name;

4169200 32765
_SYSSMU10$

select sum(blocks),count(*),segment_name from DBA_EXTENTS where tablespace_name = 'UNDO' group by segment_name;

4169200 32765
_SYSSMU10$