Oracle8i internal services for waits, latches, locks and memory

Steve Adams9781565925984, 1-56592-598-X

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, latches, locks (including instance locks, used in parallel server environments), and Oracle’s use of memory. Oracle8i Internal Services is aimed especially at administrators and developers who need detailed internal information to do advanced performance tuning. The book will expand your repertoire of tuning solutions and troubleshooting techniques by explaining how you can use Oracle’s hidden parameters and undocumented system statistics to best advantage.