Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: MONITORING
On Fri, 25 Jan 2002 18:50:31 +0100, Manuela Mueller
<520040906697-0001_at_t-online.de> wrote:
>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
Well, I tried. It was much too confusing to figure out.
Brian Received on Fri Jan 25 2002 - 13:43:10 CST