Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Monitoring dbwr with oradebug
> 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