Re: ORA-1555 error with AUM already enabled

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 25 May 2010 15:30:40 -0700
Message-ID: <AANLkTinH-MpAlIgsHs_JLF9nWB31or5CZVXBNAHasOPO_at_mail.gmail.com>

On Tue, May 25, 2010 at 3:22 PM, Janine Sisk <janine_at_furfly.net> wrote:

> EXP-00056: ORACLE error 1555 encountered
> ORA-01555: snapshot too old: rollback segment number 1 with name
> "_SYSSMU1_3780397527$" too small
>
> I checked the parameters that control automatic undo management and found
> them to be set correctly:
>
> SQL> show parameter undo
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> undo_management string AUTO
> undo_retention integer 900
> undo_tablespace string UNDOTBS1
>
>
>

Janine,

The undo_retention parameter is the amount of time in seconds that oracle will try to maintain undo to rebuild queries.

You can still run out of space.
What does this query show:

select * from dba_data_files where tablespace_name like '%UNDO%'

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

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

Received on Tue May 25 2010 - 17:30:40 CDT