UNDO Error

From: Ebadi, Abdul <Abdul.Ebadi_at_Level3.com>
Date: Fri, 13 Feb 2015 22:18:07 +0000
Message-ID: <2B2D8E96233804478FA849965DF3B2C1F17B9446_at_USIDCWVEMBX09.corp.global.level3.com>


We recently upgraded our db from 10g to and all of a sudden application is getting max extents reached error for UNDO:

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

There is plenty of space in the undo tablespace. Any suggestions beside committing more often? They never got this error before in 10g.


Received on Fri Feb 13 2015 - 23:18:07 CET

Original text of this message