This concise book contains detailed information about Oracle internals -- information that's not readily available to Oracle customers. It lays a foundation for advanced performance tuning of the Oracle database. Based on Oracle8i release 8.1, the book describes many of the secrets of Oracle's internal services: data structures, algorithms, and undocumented Oracle system statistics. Main topics include:

Waits - how Oracle processes communicate via semaphores, and how to use the Oracle wait statistics to identify the source of performance problems.Latches - how they keep...