Re: Event 10046

You can also format your event10046 trace files by web based SQL analyzer itrprof.
it's at http://www.unal-bilisim.com/products/itrprof/itrprof.html

it finds bottlenecks and offers information on how to tune them.

regards...

In article <tfi5sb7f11hn3f_at_beta-news.demon.nl>, Sybrand Bakker <postbus_at_sybrandb.demon.nl> writes:
>
>"Ivan Bajon" <bajon_at_nospam@worldonline.dk> wrote in message
>news:9db2dk$9dl$1_at_news.inet.tele.dk...
>> Hi folks
>>
>> Could someone please tell me how to enable event 10046 for another session
>> than "my own"?
>>
>> Regards,
>> Ivan Bajon
>>
>>
>
>You need to run svrmgrl
>then
>oradebug set ospid <the spid of v$process for the affected session
>oradebug set event '10046 trace name context forever, level 12'
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
>
>
>

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net