Re: Monitoring dbwr with oradebug

From: Yong Huang <yong321_at_yahoo.com>
Date: 26 Jun 2001 21:25:28 -0700
Message-ID: <b3cb12d6.0106262025.54eb3462@posting.google.com>

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?

Yong Huang
yong321_at_yahoo.com

Knut Talman <knut.talman_at_mytoys.de> wrote in message news:<3B390577.42335BC4_at_mytoys.de>...
> 6. oradebug event 10046 trace name context forever, level 10

> WAIT #0: nam='db file parallel write' ela= 0 p1=1 p2=0 p3=0
> WAIT #0: nam='rdbms ipc message' ela= 308 p1=300 p2=0 p3=0
>
> Problem: The whole trace file is full with 'db file parallel write'
> lines
> but in every line p3 is 0!?!
>
> Why are there no blocks written? What am I doing wrong?
> In my testcase I did a lot of INSERTs and UPDATEs during trace enabled.
Received on Tue Jun 26 2001 - 23:25:28 CDT