-
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?
-
Hi
Whatz your DB_BLOCK_LRU_LATCHES set???
-
What is your parameter db_writer_processes set to?
.
You cannot have this and dbwr_io_slaves set at the same time!
Brgds,
-
thanks all for replying..
i did a grep of initsid.ora of db, but no such parameters are set in my initsid.ora
-
apologies.. i have this set db_block_lru_latches = 20
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|