DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: DBWR count

  1. #1
    Join Date
    Oct 2000
    Posts
    20
    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!

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Has PADDR column in v$bgprocess got any value in DBWR?

  3. #3
    Join Date
    Oct 2000
    Posts
    20
    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


  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if PADDR is 00 then that means there isnt any extra DBWR

  5. #5
    Join Date
    Oct 2000
    Posts
    20
    But why don't the NAME colum show only one DBWR process but several process in it?

  6. #6
    Join Date
    Jan 2000
    Location
    paris
    Posts
    11
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width