Professional Web Applications Themes

Cannot start multiple dbwrs when using I/O slaves - Oracle Server

i have multiple "Cannot start multiple dbwrs when using I/O slaves" entries in my alert file. upon checking the parameters, i have this database writer and database I/O slaves set at the same time. upon doing some reading, realise that i cant have these two at the same time unless i have DB_BLOCK_LRU_LATCHES too, am i right? however, what my colleague managed to start oracle, is not to configure any of these parameters but instead 2 other which are the number of processes and lock_sga. afterwhich, the multiple dbwrs messages are gone. comments?...

  1. #1

    Default Cannot start multiple dbwrs when using I/O slaves

    i have multiple "Cannot start multiple dbwrs when using I/O slaves"
    entries in my alert file. upon checking the parameters, i have this
    database writer and database I/O slaves set at the same time.

    upon doing some reading, realise that i cant have these two at the
    same time unless i have DB_BLOCK_LRU_LATCHES too, am i right?


    however, what my colleague managed to start oracle, is not to
    configure any of these parameters but instead 2 other which are the
    number of processes and lock_sga. afterwhich, the multiple dbwrs
    messages are gone.

    comments?
    yls177 Guest

  2. #2

    Default Re: Cannot start multiple dbwrs when using I/O slaves

    Hi,
    Database version and OS information would be helpful. But in sort:
    DB_WRITER_IO_SLAVES simulates asynch IO. They do not perform
    asynch IO. They are helpful only when the operating system
    donot support asynch IO. If your OS supports Asynch IO, then
    you should use multiple DBWR, and set disk_asynch_io=TRUE

    One problem of this is, if the I/O volume is very high, so that
    the OS could not handle it, In that case there is a chance that asynch
    I/O
    will time out. This will lead to crash of the database.

    Only in that case you should use slaves with setting
    disk_asynch_io=FALSE

    You can not use DBWR_IO_SLAVES and multiple DBWR process at the same
    time.

    Hope this helps,
    Thanks,
    Saikat Chakraborty

    "yls177" <com> wrote in message
    news:google.com
     




    --
    Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
    Saikat Guest

  3. #3

    Default Re: Cannot start multiple dbwrs when using I/O slaves

    "Saikat Chakraborty" <com> wrote in message news:<mailgate.org>... [/ref]

    hi.. my os is aix 4.3 and oracle is 8.0.7. sorry for my ignorance..
    but your posts doesnt really say much about what i am getting... and
    the strange thing is that my colleague changed 2 parameters, processes
    and lock_sga afterwhich the oracle could be started up.
    yls177 Guest

Similar Threads

  1. Difficulties to send multiple object in multiple objectwith SOAP (WebService)
    By laurent pinson in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: May 19th, 01:17 PM
  2. Replies: 4
    Last Post: May 22nd, 05:58 PM
  3. Replies: 2
    Last Post: February 16th, 03:25 PM
  4. Can't start acrobat 6.0 as admin have to use user mode to start
    By winstonlau@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 5
    Last Post: June 10th, 05:28 PM
  5. Replies: 0
    Last Post: September 29th, 09:13 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139