/explore
|
You are here 
|
andreynikolaev.wordpress.com | ||
| | | | |
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 |
|
| | | | | ||
| | | | |
blog.tanelpoder.com
In recent past I've blogged few scripts which use specially crafted ordered nested loop for sampling contents of V$ and X$ views fast, with plain SQL. If you haven't read them yet, here are the links: WaitProf LatchProf LatchProfX I wrote the above scripts having special purposes in mind (e.g. profile session waits or latching activity). Now I introduce a simple but powerful sqlplus script for ad-hoc sampling of any V$ view. It's called.... (drumroll) .... sample.sql :) When you look into it, the script ... |
|
| | | | | ||
| | | | |
easyoradba.com
Oracle 11.2.0.2 contains enhancements 9282521 and 9239863 named "Library cache: mutex X" for objects highly contended for. Part I and... |
|
| | | |||
