O'Reilly logo

Oracle Internals: An Introduction by Steve Adams

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Kernel Services

This book covers the kernel services for waits, latches, locks, and memory. Although there is relatively little you can do to tune these services themselves, you will need to understand them when you tune any other part of Oracle.

Chapter 2

The wait statistics are the most important Oracle statistics for advanced performance tuning. This chapter explains how to gather and use these statistics.

Chapter 3

Oracle makes extensive use of latches, and advanced performance tuning often involves the prevention of latch contention. This chapter provides a foundation for such tuning by explaining how latches are used.

Chapter 4

Oracle uses many types of locks. This chapter explains how locks are used, and how to diagnose locking problems.

Chapter 5

Oracle parallel server technology adds an extra dimension to Oracle tuning. This chapter explains how parallel server locking is implemented, and what the statistics mean.

Chapter 6

This chapter explains how Oracle’s internal memory management works. I pay particular attention to the inner workings of the shared pool, and to assessing whether it is sized correctly.

Although there is much more to Oracle internals than this small book covers, these chapters provide the foundation that you need for advanced performance tuning.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required