Re: ora-1555 not in alert log?

Hi Joel,

As David has said, ORA-1555s are not recorded in the alert log.

One nice thing with 9i is that such errors are now "logged" (or counted) in the v$undostat view. Which helps with the sizing of the undo tablespace and the undo_retention parameter.

Cheers

Richard
"David Sharples" <david.sharples3_at_ntlworld.com> wrote in message news:5upm9.193$RI6.23759_at_newsfep1-win.server.ntli.net...
> cos its not a database error, its an 'application' error
>
>
> "Joel Garry" <joel-garry_at_home.com> wrote in message
> news:91884734.0210011343.75046070_at_posting.google.com...
> > I have a client/server odbc application (packaged from a vendor, no
> > source) which returned an 'ORA-01555: snapshot too old: rollback
> > segment number 7 with name "RBS08" too small' error. However, that
> > error is not in the alert log? I see log switches subsequent to that
> > time. 8.1.7 on hp/ux, a well-tuned production instance that has no
> > errors besides expected ones from the standby db being down. SMON
> > left a trace file indicating it cleaned up after problem, taking 70
> > minutes to do so.
> >
> > I can understand the ora 1555, as some unusual processing is taking
> > place as I try do some ETL while others are doing big processing, but
> > what concerns me is why the error is not in the alert log. Yes, I've
> > triple-checked the dates and instances, it happened today on the
> > instance whose alert log I looked at.
> >
> > jg
> > --
> > @home is bogus, substitute @cox.net for email, though I'm a bit slow on
> > that these days.
> > "With Oracle9i you'll never see ORA-01555 again!" - New Features
presenter
>
>
Received on Tue Oct 01 2002 - 19:55:08 CDT