Re: Monitoring dbwr with oradebug

Hi, Nuno,

Danisment Unal, an Oracle employee I believe, has a page that lists the levels for event 10046

www.unal-bilisim.com/products/itrprof/itrprof_user_manual.html#traceFileLevels

It looks like it only allows for 1, 4, 8 and 12. But 1 is useless since people would use the documented alter session set sql_trace instead. Most people use this event at level 8, occasionally I see 4 and 12 being used. What does 10 tell you exactly?

Yong Huang
yong321_at_yahoo.com

nsouto_at_nsw.bigpond.net.au.nospam (Nuno Souto) wrote in message news:<3b39bc9e.5244064_at_news-server>...
> On Wed, 27 Jun 2001 12:51:17 +0200, Knut Talman
> <knut.talman_at_mytoys.de> wrote:
>
> >> I remember the level for event 10046 should be power of 2 beginning
> >> with 4, or their addition. So 4, 8 and 12 are valid. Where did you get
> >> 10?
> >
> >An Oracle consultant told me... But I even tried it with 16 and 8 with
> >the same result.
> >
>
> Folks, the powers of two are there to set specific bits of a word.
> Eg: (d=decimal, b=binary)
>
> d8 = b100 (third bit set)
>
> d10 = b1010 = 8 + 2 (powers of two) (fourth and second bits set).
>
>
> Cheers
> Nuno Souto
> nsouto_at_bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html
Received on Wed Jun 27 2001 - 23:03:13 CDT