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!
Printable View
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!
Has PADDR column in v$bgprocess got any value in DBWR?
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
if PADDR is 00 then that means there isnt any extra DBWR
But why don't the NAME colum show only one DBWR process but several process in it?
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