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.
The wait statistics are the most important Oracle statistics for advanced performance tuning. This chapter explains how to gather and use these statistics.
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.
Oracle uses many types of locks. This chapter explains how locks are used, and how to diagnose locking problems.
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.
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.