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

Thread: multiple dbwrs in alert file error

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    multiple dbwrs in alert file error

    i have this message in my alert file. "Cannot start multiple dbwrs when using I/O slaves". and in my initSID.ora, i have set dbwr_io_slaves = 4

    am i missing somethings?

  2. #2
    Join Date
    Oct 2003
    Posts
    65
    Hi
    Whatz your DB_BLOCK_LRU_LATCHES set???

  3. #3
    Join Date
    Feb 2001
    Location
    Adelaide, Australia
    Posts
    159
    What is your parameter db_writer_processes set to?
    .
    You cannot have this and dbwr_io_slaves set at the same time!

    Brgds,

  4. #4
    Join Date
    Oct 2002
    Posts
    391
    thanks all for replying..

    i did a grep of initsid.ora of db, but no such parameters are set in my initsid.ora

  5. #5
    Join Date
    Oct 2002
    Posts
    391
    apologies.. i have this set db_block_lru_latches = 20

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by yls177
    thanks all for replying..

    i did a grep of initsid.ora of db, but no such parameters are set in my initsid.ora
    well they already told you that you cannot have database writer and database I/O slaves at te same time

  7. #7
    Join Date
    Oct 2002
    Posts
    391
    yes.. u are right. thanks!

    okay, after i have changed these parameters, in my alert file, i had this entry

    Thread recovery: start rolling forward thread 1
    Recovery of Online Redo Log: Thread 1 Group 9 Seq 194159 Reading mem 0
    Mem# 0 errs 0: /oracle/SID/origlogA/log_g9m1.dbf
    Mem# 1 errs 0: /oracle/SID/mirrlogA/log_g9m2.dbf
    Fri Nov 21 06:20:50 2003
    Thread recovery: finish rolling forward thread 1
    Thread recovery: 9 data blocks read, 0 data blocks written, 52 redo blocks read
    Crash recovery completed successfully
    Picked broadcast on commit scheme to generate SCNs

    the oracle managed to startup..

    but in my usertrace, i had a file which had the below entries


    *** SESSION ID:(25.1) 2003-11-21 06:18:59.119
    ******** ERROR: SGA memory leak detected 488 ********
    ******************************************************
    HEAP DUMP heap name="sga heap" desc=0xc0000000afa02040
    extent sz=0xfe0 alt=96 het=32767 rec=9 flg=2 opc=0
    parent=0 owner=0 nex=0 xsz=0x2b443680
    EXTENT 0
    Chunk c000000084001010 sz=362946168 perm "perm " alo=97401536
    Chunk c000000099a22e88 sz=320576864 free " "
    Chunk c0000000acbdcbe8 sz= 488 freeable "ksfv i/o slave "
    Chunk c0000000acbdcdd0 sz= 371264 free " "
    Chunk c0000000acc37810 sz= 40 R-freeable "reserved stoppe"
    Chunk c0000000acc37838 sz= 41943040 R-free " "
    Chunk c0000000af437838 sz= 40 R-freeable "reserved stoppe"



    i am not sure about what happened above. thanks

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