Mutex Errors
85558Jul 22 2010 — edited Mar 28 2011I've started receiving notices from a database monitoring tool with the following information:
Warning: Mutex contention on ora2-prod is at 564.00 lock attempts per second. This signifies a multi-processing overload condition.
But I can't seem to track down what might be causing this issue (and it's happening more and more) nor how to handle it. Also, I can't seem to find any information on what a good threshold for triggering this error might be. Is "564.00 lock attempts per second" high? What's a "good" value? How high can it go before I hit the alarm for general quarters?
If it's significant, this particular server (ORA2-PROD) is the secondary node of a two-node cluster. Both nodes are running on identical Sun Solaris boxes. Any and all help gratefully appreciated.
Leigh Smith