Oracle Performance Firefighting
by Craig Shallahamer

Get the book here



Craig Shallahamer's Blog

You were brought to this page based on an internet search and as a free service to Oracle DBAs.

The text below is an except from the book, Oracle Performance Firefighting, written by Craig Shallahamer of OraPub, Inc. Figures and tables are not included on this page, only their reference.
To order the book in either print or PDF form, click here.


©2009, 2010 by Craig Shallahamer. This is copyrighted material.
Please—Out of respect for those involved in the creation of the book and also for their familes, we ask you to respect the copyright both in intent and deed. Thank you.

-------------------------------

Figure 3-14. An example of false contention. If process P100 wants access to memory structure MS1 and process P200 wants access to memory structure MS2, they will both contend for the same control structure CS999, resulting in false contention.

Another consequence associated with false contention is control structure contention. For example, suppose you want to build a shed to store farm equipment, but you must first obtain a permit. Many other people also want to build sheds, so the governmental office is overwhelmed with permit requests. To ensure there is no illegal builder collaboration, each permit is serially reviewed. As you can imagine, during peak permit submission times, the permit review process can experience long delays. In this situation, acquiring the permit is the bottleneck, not shed construction.

Relating this to Oracle, the bottleneck would be acquiring the control structure, not accessing the underlying memory structure. When complex memory structures are protected by a limited number of latches, solutions focused on the control structure are to either add control structures (for example, specialized governmental permit reviewers) or decrease the control structure access time (for example, streamline the permit review process). In Oracle terms, this means either add more latches and improve latch acquisition performance or optimize the kernel code accessing the memory structure. A creative option is to not use latches at all, but instead use a completely different structure that inherently provides both of these benefits-like a mutex! Reducing the likelihood of control structure contention is another reason mutexes are an attractive memory control option.

©2009, 2010 by Craig Shallahamer. This is copyrighted material.
Please—Out of respect for those involved in the creation of the book and also for their familes, we ask you to respect the copyright both in intent and deed. Thank you.


Know what's important before it's too late!

OraPub's
Performance Training

is like no other...





More Class Pics...
Get student testimonials!