Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Monitoring dbwr with oradebug

Re: Monitoring dbwr with oradebug

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Thu, 28 Jun 2001 11:34:10 +0200
Message-ID: <3B3AFA12.4C9F446C@mytoys.de>

> 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?

When I use level 10, I see *only* WAITs in the trace file (and in my case I only need WAITs), so level 10 seems to be the right one.

Cheers,

Knut Received on Thu Jun 28 2001 - 04:34:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US