Re: UNDO Error

From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Fri, 13 Feb 2015 15:37:11 -0700
Message-ID: <54DE7C97.7030701_at_gmail.com>

While you are waiting for a response, check out http://www.orafaq.com/wiki/Rollback_Segment ... one thing I'd be looking at is the retention period.

And 'committing more often' would be a last resort, as it creates it's own problems.

/Hans

On 13/02/2015 3:18 PM, Ebadi, Abdul wrote:
>
> Hello,
>
> We recently upgraded our db from 10g to 11.2.0.4 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.
>
> Thanks,
>
> Abdul
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 13 2015 - 23:37:11 CET