That certainly sounds like the solution to the immediate problem. (Mind you, those initial numbers look like generated values, not manual settings).
However, it doesn't answer the question of why one of the machines has the problem. Do you think it;s possible that lots of material gets loaded and KEEP'ed in this instance before the other instance starts up, making this instance the resource master for a very large dictionary cache ? Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -----Original Message----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 02 May 2002 22:44 |Check out the following two values: | |Resource Current Max Initial Limit |Name Utilization Utilization Allocation Value |---------- ---------- ---------- ---------- -------- |lm_ress 252143 256732 177599 UNLIMITED |lm_locks 278106 288642 189208 UNLIMITED | |Notice that "Current/Max Utilization" is much higher than "Initial |Allocation"? | |This means that (messages to alert.log or not), the DLM is overflowing its |allocated space in the SGA and invading the Shared Pool. Increase your |LM_RESS and LM_LOCKS parameter values... | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
