Re: capture oracle errors

You can set an event in your INIT.ORA to generate a trace file when a specific Oracle error is reached. Does that help solve your problem? For instance, to capture ORA-901 add the following to your INIT.ORA and bounce the database:

EVENT="901 TRACE NAME ERRORSTACK FOREVER" HTH,
Brian

Hegyvari Krisztian wrote:
>
> Greetings,
>
> I am looking for a tool similar to SQL MOnitor from Quest software.
> What I would like:
>
> - the tool would be sitting silently in the background (an open window
> is not a problem, or perhaps something on the tray)
> - the tool logs only those calls which causes an Oracle error,
> together with the sql command and the bound variables
> - it has to be able to handle long batch processes without exhausting
> system memory resources (that's the problem with sql monitor)
>
> Any ideas?
>
> Best regards,
>
> Hegyvari Krisztian
>
> pls cc to hegyvari_at_ardents.hu

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"