Serialization is huge! Smooth Oracle latching and mutex operation is critically important. If there are problems in this area, parallelization suffers a grinding and painful slowdown.

I've presented many technical details in this chapter. The goal was to help you understand serialization, Oracle's general latching and mutex algorithms, latching and mutex specifics, and how to identify when there is significant latching and mutex contention to warrant your attention. You will be able to combine your latching and mutex understanding with Oracle internal algorithms (for example, CBC operations) and proven methodologies to come up with creative, practical, and powerful solutions. So this chapter will become practical only when combined with a proven methodology and a solid understanding of Oracle internals. None of these three components used alone will produce an exceptional performance analysis.

And finally, don't let anyone tell you that once you've hit latching contention, you can't do anything more. As this book is beginning to reveal, there is a very diverse and practical set of solutions to each latch and mutex contention scenario.