Hotsos Symposium 2012 will be held March 4-8, 2012 in Irving, TX. There will be 31 speakers and 36 sessions dedicated to Oracle performance. Where else can you get this kind of in-depth discussion dedicated to Oracle performance? Plus, Jonathan Lewis is hosting the optional Training Day. Register today! You don't want to miss the 10th anniversary of Hotsos Symposium.
Biography: Andrey Nikolaev was first met with Oracle 5 in 1988. Since that time his professional interests have evolved from high performance particle physics computing, through application development, to database performance consulting, but always stay centered on performance. Working in RDTEX, Russian First Line Support company, he devotes his time to tuning and diagnosing the largest Oracle databases in Russia. As an Oracle University trainer, Andrey taught the full spectrum of Oracle database administration courses.
Topic: Mutex Internals
Abstract: KGX mutexes is new type of spinlocks used in the latest Oracle versions. Despite being known since 2005, mutex is still Terra incognita. The mutex contention is frequently observed in high concurrency OLTP environments.
Using oradebug and DTrace, this presentation explores how mutex operates, spins, and sleeps. It will show how Oracle instruments the mutex operations; discuss parameters and statistics related to mutex performance diagnostics and tuning.