DBWR count

[terrykingfa]

In my database(ORACLE8i running on NT4.0), I set dbwr_io_slaves to 2.But when I view v$bgprocess view ,I saw more than one DBWR process existing in my DB.Why?
Thanks in advance!

[pando]

Has PADDR column in v$bgprocess got any value in DBWR?

[terrykingfa]

Hi Pando
In v$bgprocess, the PADDR value like this:

PADDR NAME DESCRIPTION
-------- ----- ---------------------------------
02311F7C PMON process cleanup
00 LMON lkmgr monitor
00 LMD0 lkmgr daemon 0
00 TRWR trace writer process
023122A0 DBW0 db writer process 0
00 DBW1 db writer process 1
00 DBW2 db writer process 2
00 DBW3 db writer process 3
00 DBW4 db writer process 4
00 DBW5 db writer process 5
00 DBW6 db writer process 6
00 DBW7 db writer process 7
00 DBW8 db writer process 8
00 DBW9 db writer process 9

[pando]

if PADDR is 00 then that means there isnt any extra DBWR

[terrykingfa]

But why don't the NAME colum show only one DBWR process but several process in it?

[laurence]

Hi !

May be i'm wrong !

But, i think there is only one DBWR process because there is
only one thread. And the thred contains several process in it.

I don't know any further.

LAurence