Re: ora-1555 not in alert log?

"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

[slaps forehead] Man, I totally forgot! I'm so used to my systems not having this problem. In the past when I've walked into places that have this problem, they usually had a bunch of other stuff in the alert logs they didn't know enough to look in, so I must have mentally transferred 1555 there.

I guess this means the application should be responsible for tuning RBS's! :-)

Turns out the error they didn't tell me about was ORA-04030, which makes a lot more sense. Let's hear how wonderful tiered applications are when they give a different error to the user than to the middle tier log. So now I'm off to check the swap, and look for something in the patch set about memory leaks so I can convince the boss we really should be latest patched (he's against patching just because O puts out a set).

>
>
> "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

jg

--
@home is bogus
"I'm Troy McClure, you may have seen me in the driver training film 'Alice 
Through the Windshield Glass'..." - Simpsons, Brother From the Same Planet