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

Thread: DBWRs and IO_SLAVES vs. Async IO

  1. #1
    Join Date
    Apr 2007
    Posts
    31

    DBWRs and IO_SLAVES vs. Async IO

    We're using Oracle 10.2.0.4 on Solaris 10 with async turned on in the DB and async on in the OS. Our db_writers is set to 4, io_slaves is set to 0. We're noticing slow DBWR performance on our PROD server and much faster performance on our TEST server, both are the same systems, same patch level and same configurations for Oracle. I've recently seen some documentation that states you should use one or the other, if using async io set db_writers = 1 (and possibly io_slaves as well) otherwise if not using async io set db_writers = 4 and set io_slaves = 4 (or whatever recommended values based on CPU). Does anyone have any insight into this? We trying to determine why the DBWR is slow, LOG writer is fast, CPU isn't terribly busy, IO doesn't seem busy however we're getting GC alerts that say "Disk Device Busy (%)" at 98% sometimes but I can't find the command that GC uses to determine this in GC's documentation with all of the other alerts and their associated commands.

  2. #2
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    This is from Oracle Docs. I hope it will help you.

    DBWR_IO_SLAVES: This parameter is only relevant on systems with only one database writer process (DBW0). This parameter specifies the number of I/O slaves that is used by the DBW0 process. The DBW0 process and its slaves always write to disk. By default, the value is 0 and I/O slaves are not used.
    If DBWR_IO_SLAVES is set to a nonzero value, the numbers of I/O slaves used by the ARCn process and LGWR process is set to 4. However, the number of I/O server processes used by Recovery Manager is set to 4 only if asynchronous I/O is disabled (either your platform does not support asynchronous I/O or DISK_ASYNCH_IO is set to false.
    Typically, I/O slaves are used to simulate asynchronous I/O on platforms that do not support or implement it inefficiently. However, I/O slaves can be used even when asynchronous I/O is being used. In that case, the I/O slaves use asynchronous I/O.
    lucky

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Thumbs down Filesystemio_options

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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