Re: MONITORING

Brian Tkatch wrote:
>
> On Fri, 25 Jan 2002 00:22:23 +0000 (UTC), "John Darrah"
> <jdarrah_at_veripost.net> wrote:
>
> >Brian,
> >
> >Have you tried setting event 10046 on the session and then running the
> >gather stale procedure? You might see the SQL in the tracefile. Just a
> >thought.
> >
> >
> >
> >
> >
> >--
> >Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
>
> Intreresting. But forgive me, I am not yet familiar with setting an
> event. This would be a good exercise is tracing though.
>
> How do I set the event, and why specifically that event?
>
> Brian

Hello Brian,
the same question arised for me. Found nothing in the original docs, but followed Thomas Kyte's advice in his book: go to google.com, do a search for 'alter session set events 10046' Short info on event numbers is available with oerr: eg: $ oerr ora 10046
10046, 00000, "enable SQL statement timing" // *Cause:
// *Action:

One of the search results was a link to orafaq (database internals faq): http://orafaq.cs.rmit.edu.au/faqdbain.htm # Trace SQL statements and show bind variables in trace output event = "10046 trace name context forever, level 12"

Also take a look at:
http://www.ixora.com.au/q+a/events.htm
Have a nice day
Manuela Mueller Received on Fri Jan 25 2002 - 11:50:31 CST