Re: ora-1555 not in alert log?

joel-garry_at_home.com (Joel Garry) wrote in 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

Yes, you are correct.
Most likely it is because the code is doing "multiple" commits; such as COMMIT after every 10,000 rows have been inserted; instead of a single COMMIT at the end. Received on Tue Oct 01 2002 - 19:50:15 CDT