|
You are here |
easyoradba.com | ||
| | | | |
andreynikolaev.wordpress.com
|
|
| | | | | 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 | |
| | | | |
yorakb.wordpress.com
|
|
| | | | | 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/ | |
| | | | |
jagjeet.wordpress.com
|
|
| | | | | 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 | |
| | | | |
greatmusclemasstips.wordpress.com
|
|
| | | This is your very first post. Click the Edit link to modify or delete it, or start a new post. If you like, use this post to tell readers why you started this blog and what you plan to do with it. Happy blogging! | ||