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.
Regards Rafiq
Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Sat, 07 Jun 2003 10:49:46 -0800
hi we have upgraded a database from 8.1.7.4 on aix 4.3 to 9.2.0.3 on 5l and was running fine for the past two weeks. it all started day-before-yesterday when job queue coordinator started thrwoing 4031 errora and dbwr crashed eventually. we increased the shared pool and again the crash happened the next day.
in 8i the shared memory was 120M and i had a shared memory of 200Mb initally in 9i (dont know why??) ,later increased to 300mb after the first crash,then to 650mb after the second crash(oracle's suggestion).oracle send me some events to be set in init.ota for 4031 errors and the trace that generated it seems has very little info to debug..not surprised..job queue coordinator,apparently wakes up every 5 seconds and there is some bug filed regarding excessive usage of sga by job queue coordinator. oracle suggested about the _job_queue_interval parameter and i went ahead and put that in setting it to the same value as in 8i. oracle sent me a script which added sharable_mem from v$db_objcect_cache and v$sqlarea and told me that i have to double the shared memeory. i dont hv a clue though i think this is not a right way to check the shared pool size. also the application is the same.nothing has changed and the number of processes in the database at any point of time is less than 50!!! does 9i require 5 times the size of share pool of 8i ???? has anyone faced this kind of issue? i have been sitting in front of the system for the past two days trying to figure out what is happening? cant question oracle..but why really mess around with job queue processes when that simple daemon has been working fine in all versions?
anycase,gurus please help me out on this.
thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sai Selvaganesan INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also 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 Rafiq INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
