Outer Web | Explore

/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.

You are here		easyoradba.com Divide and conquer the "true" mutex contention - EasyOraDBA
\|	\|	yorakb.wordpress.com Kill libary cache : mutex x wait \| Yorakb check executions, parse_calls and version_count in v$sqlarea. If no issue identified : increase _kgl_hot_object_copies (default is number of cpu). If still not good, identify the most pinned cursors in shared pool : Then mark the cursor as hot : Ref : https://jagjeet.wordpress.com/2011/12/12/library-cache-mutex-x/ https://andreynikolaev.wordpress.com/2011/05/01/divide-and-conquer-the-true-mutex-contention/	11.5 parsecs Travel
\|	\|
\|	\|	andreynikolaev.wordpress.com Divide and conquer the true mutex contention \| Latch, mutex and beyond Oracle 11.2.0.2 contains enhancements 9282521 and 9239863 named Library cache: mutex X" for objects highly contended for. Part I and II. These enhancements introduce new interesting possibilities to tune some types of the mutex contention. Contention for heavily accessed objects can now be divided between multiple copies of object in the library cache. According to	13.9 parsecs Travel
\|	\|
\|	\|	jagjeet.wordpress.com Library cache: mutex X \| Jagjeet's Oracle Blog! Recently, I was engaged in Exadata POV for benchmarking for Ebiz R12 on Exa* boxes. We had quarter rack running 11.2.0 db with 2 node RAC Cluster (24 CPU) and all other components/Middle Teir including Form, Web, CM were configured on Exalogic Server. Objective was to achieve best possible scalability numbers on Exa* boxes for	11.8 parsecs Travel
\|	\|
\|	\|	blog.neverendingqs.com Switch to Jekyll Hobbyist software developer by night.	15.5 parsecs Travel
\|