Re: UNDO Error

From: Rodrigo Mufalani <rodrigo_at_mufalani.com.br>
Date: Fri, 13 Feb 2015 20:50:47 -0200
Message-Id: <365AA547-E25B-4417-A100-DF36E341930D_at_mufalani.com.br>

I search on Google and found this blog note http://dbakevin.blogspot.com.br/2012/03/ora-1628-max-extents-32765-reached-for.html?m=1

Maybe you run into this case.

[ ]'s
#mufalani

   Desculpe por erros! Este e-mail foi escrito do meu smartphone!

    Sorry for typos! This mail was written from my smartphone!!!

> On 13/02/2015, at 20:18, Ebadi, Abdul <Abdul.Ebadi_at_Level3.com> 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:50:47 CET