Bryan, There have been issues with this hanging problem with OPS in some releases. I am not sure if this is the problem, but applications that heavily use the rowcache in an OPS environment can have performance problems if the shared_pool is loaded and cause sudden hangs when the row cache object is being flushed from the shared pool. This problems should have been fixed with 8171 but it appears that the fix is in 8173.
Hope this helps, Scott --- "Rodrigues, Bryan" <[EMAIL PROTECTED]> wrote: > No messages in the alert log about dynamic lock > allocation, the node that is > having the issue has a small load on it right now > and the memory is still > being used up. > > Thanks > > -----Original Message----- > Sent: Thursday, May 02, 2002 3:29 PM > To: Multiple recipients of list ORACLE-L > > > Any messages in the alert file, like dynamic lock > allocation or resource > allocation ? > In Oracle8 locks and resources for OPS are > dynamically allocated from the > shared pool after the initial values of _LM* are > used. > You can monitor that in v$resource_limit. > > Anjo. > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 9:03 PM > > > > Hello, > > We are working on (2) HP 9000 64 bit HP-UX 11.0 in > an OPS cluster (non > mts) > > on version 8.1.7.2.1 32 bit, we were encountering > ora-4031 errors on one > of > > the instances, so we increased the amount of > shared pool memory from 100mb > > to 200mb on both nodes in the cluster. Since the > shared pool memory was > > increased the instance on the node that had the > error is no longer > > encountering it. But now the instance on the other > node that was not > having > > any issue, is able to keep only 1% of the shared > pool memory free and has > > hung 2 times. We are working with Oracle, but > would appreciate any ideas. > We > > know that we have 'bind variable' issues, but not > enough to get us into > the > > situation that we now face. > > > > > > Thank you, > > > > Paul Sherman > > DBA Elcom, Inc. > > voice - 781-501-4143 (direct #) > > fax - 781-278-8341 (secure) > > email - [EMAIL PROTECTED] > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Sherman, Paul R. > > 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). > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Anjo Kolk > 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). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Rodrigues, Bryan > 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). __________________________________________________ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott 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).
