Re: ora-1555 under automatic undo management (resend ?)

> I'm having an ora-1555 under Oracle9 database and not
> sure what I can do to get rid of it. I had some
> recollecions from Oracle8 days , but the things like
> adding a new rollback segment or shrinking the
> segments I don't think are applicable under the auto
> undo management. Besides separating the long queries
> from batch programs, is ther anything that I can do
> here?

Hi Gene,

Increase UNDO_RETENTION (which determines how long Oracle will attempt to keep your undo before being overwritten) and/or increase the size of your undo tablespace (to ensure Oracle will succeed in meeting your undo_retention target).

Check out V%UNDOSTAT to see how it's going.

Cheers

Richard

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Foote
  INET: richard.foote_at_bigpond.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).