RE: ORA-1555

I second this. Have you checked how long the query that received the 1555 error runs for and made sure that undo_retention is larger than this?

Jay Miller
Sr. Oracle DBA
x68355  

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Alex Gorbachev Sent: Sunday, February 04, 2007 11:04 AM To: smishra_97_at_yahoo.com
Cc: oracle-l_at_freelists.org
Subject: Re: ORA-1555

Check undo_retention parameter.

On 2/4/07, Sanjay Mishra <smishra_97_at_yahoo.com> wrote:
> Hi everybody
>
> I have seen several time ORA-1555 error in few of the Prod Database.
SOme of
> them have very big UNDO tablespaces. All are 9i Databases. What are
the
> other option that need to be checked for such issue beside increasing
the
> space as some of the database has UNDO tablespace around 50-150G
>
> Is it good to create new undo tablespace and make it default in such
> scenario and later on dropped the old. Do somebody has set of UNDO
checking
> query that can be ran at some particular point to really see if that
big
> UNDO are really been used so that it can be resized.
>
> I am thankful for any suggestion for monitoring such ORA-1555 as well
as
> query to check UNDO segment space.
>
> TIA
> Sanjay
>
> ________________________________
> Finding fabulous fares is fun.
> Let Yahoo! FareChase search your favorite travel sites to find flight
and
> hotel bargains.
>
>

-- 
Best regards,
Alex Gorbachev

The Pythian Group
Sr. Oracle DBA

http://www.pythian.com/blogs/author/alex/
http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l


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