Oracle8i Internal Services for Waits, Latches, Locks, and Memory - Adams, Steve

. .

Résumé :
This concise book contains detailed information about Oracle internals-information that's not readily available to Oracle customers. 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, which are used in parallel server environments), and memory use and management. The author's toolkit of scripts accesses the Oracle X dollars tables directly to return statistics you'll find extremely he1pful in tuning and analysis. 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. "The Oracle wait events are probably the most important piece of tuning information for any Oracle DBA. In this book Steve Adams gives a good introduction to the most important wait events and also offers information on bow to tune them." Anjo Kolk, Oracle Corporation "Steve Adams knows more about Oracle internals than anyone I know. This book is a very significant contribution to the body of Oracle knowledge and an invaluable aid to advanced performance tuning and configuration. I highly recommend it. " Guy Harrison, Project Manager, Database Monitoring Tools, Quest Software "Steve bas taken Oracle internals information to the next level. The book is a 'must read' for every DBA and senior technical person who's working on mission-critical Oracle databases. It is a welcome addition to my bookshelf. " Mark Gurry, Author of Oracle Performance Tuning

Biographie:
Steve Adams runs a small consulting company, Ixora, that specializes in advanced Unix and Oracle performance tuning. He is based in Sydney, Australia, but also works remotely for clients in America and Europe. Steve is a regular contributor to various Oracle discussion forums on the Internet, where he is widely regarded as the leading performance expert. His experience with Oracle dates back to version 3 (1984). However, most of his work has been in Unix performance tuning. His interest in Oracle-and Oracle internals in particular-was rekindled when working as the Unix performance expert on a benchmark of an Oracle-based application in 1995. He found the challenge of understanding Oracle performance to be extremely demanding, and yet irresistible. Steve doesn't yet claim to have mastered the topic of Oracle performance, but he does have plenty of insight to share. He can be contacted directly at mail via his company's web site at http://www.ixora.com.au/.

Sommaire:
["Waits","Latches","Locks","Instance Locks","Memory."]