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.

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

* Understand the general latch and mutex algorithms. This is what this chapter is all about. If you don't understand the fundamentals of serialization, your solutions are pretty much guesses-you honestly don't know if they will help improve performance.

* Detect significant latch and mutex contention. Every production Oracle system contains latch and mutex contention. If this were not the case, Oracle would be out of business, and nonconcurrency control products would be used instead. The issue is not whether contention exists; it's whether contention is a performance problem. As you'll see, Oracle's wait interface tells us if there is enough serialization to prompt us to act.

* Determine the problematic latch or mutex. With rare exception, the best solutions are latch- and mutex-specific, which means they are not general, but target a specific latch or mutex. Knowing the contention exists is not enough for a pinpoint diagnosis. You need to determine specifically which latch is the problem. Again, Oracle's wait interface provides us with this information.

©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!