java pool size is set to 60 M in our environment.
saiM Rafiq <[EMAIL PROTECTED]> wrote:
Have you using java or by default any java objects installed. Ckeck for size of java pool which has default of 20M. If yes, try to increase size of java pool to min 50M. I have read some place that in newer version this 4031 message is misleading and may be result of java pool size.RegardsRafiqReply-To: [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L Date: Sat, 07 Jun 2003 10:49:46 -0800hiwe have upgraded a database from 8.1.7.4 on aix 4.3 to9.2.0.3 on 5l and was running fine for the past twoweeks.it all started day-before-yesterday when job queuecoordinator started thrwoing 4031 errora and dbwrcrashed eventually. we increased the shared pool andagain the crash happened the next day.in 8i the shared memory was 120M and i had a sharedmemory of 200Mb initally !
in 9i (dont know why??),later increased to 300mb after the first crash,thento 650mb after the second crash(oracle'ssuggestion).oracle send me some events to be set ininit.ota for 4031 errors and the trace that generatedit seems has very little info to debug..notsurprised..job queue coordinator,apparently wakes upevery 5 seconds and there is some bug filed regardingexcessive usage of sga by job queue coordinator.oracle suggested about the _job_queue_intervalparameter and i went ahead and put that in setting itto the same value as in 8i. oracle sent me a scriptwhich added sharable_mem from v$db_objcect_cache andv$sqlarea and told me that i have to double the sharedmemeory. i dont hv a clue though i think this is not aright way to check the shared pool size. also theapplication is the same.nothing has changed and thenumber of processes in the database at any point oftime is less than 50!!! does 9i require 5 t!
imes thesize of share pool of 8i ????has anyone faced this kind of issue? i have beensitting in front of the system for the past two daystrying to figure out what is happening? cant questionoracle..but why really mess around with job queueprocesses when that simple daemon has been workingfine in all versions?anycase,gurus please help me out on this.thankssai--Please see the official ORACLE-L FAQ: http://www.orafaq.net--Author: Sai SelvaganesanINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list!
you want to be removed from). You mayalso send the HELP command for other information (like subscribing)._________________________________________________________________Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: M RafiqINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).</BLOCKQU!
OTE>
Received on Sat Jun 07 2003 - 16:33:05 CDT
