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 multiple processes from inspecting protected data structures at the same time, and how to examine and control latch behavior and statistics.
Locks - how they work with latches to protect data structures (locks allow multiple sessions to share resources in some cases), and how locks affect performance. There is also a detailed discussion of instance locks, which are used in parallel server environments.
Memory - how Oracle uses memory (e.g., the various elements of the System Global Area), and how Oracle dynamically allocates and manages 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.
NOTE: The author has collected the scripts he has developed for tuning and analysis into a toolkit (known as APT, for Advanced Performance Tuning). These scripts access the Oracle X$ tables directly and provide information not otherwise available. The scripts are available to readers for free from the O'Reilly web site.
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 firstname.lastname@example.org or via his company's web site at http://www.ixora.com.au/.
Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animal on the cover of Oracle 8i Internal Services is a bumblebee. Only three types of bees are social insects: bumblebees, honeybees, and tropical stingless bees. There are approximately 200 species of bumblebee, most of which reside in temperate zones, where their thick layer of hair protects them from cool temperatures. In early spring the queen bee emerges from underground hibernation and searches for a nesting site, often in a deserted rodent nest. She then makes a honey pot of secreted wax, and a cell into which she places pollen and lays the first of her eggs. When these eggs hatch, the larvae grow into small worker bees. Later broods of eggs grow into bigger bees, as the queen now has help gathering food for the larvae. Toward the end of the breeding season, males and young queens are produced. By late autumn, the entire colony has died, with the exception of the young queens, who scatter to find places to hibernate until the following spring, when they will begin their own colonies.
The disproportionate appearance of bumblebees is deceptive. Despite their large, apparently clumsy bodies and delicate wings, they move swiftly and efficiently, pollinating flowers as they go. Bumblebees play an important role in pollinating flowers such as the red clover, in which the nectar is too deep down for most bees to reach. This is because the bumblebeeÂ¹s tongue is, on average, 2.5 mm longer than other that of other bees. In New Zealand, English settlers discovered that the red clover that they transported and planted did not thrive until they imported bumblebees to aid with pollination. Colleen Gorman was the production editor and proofreader for Oracle 8i Internal Services; Nicole Gipson Arigo and Jeff Holcomb provided quality control. Mike Sierra provided FrameMaker technical support. Steve Adams wrote the index.
Ellie Volkenhausen designed the cover of this book, using an original drawing by Lorrie LeJeune. Kathleen Wilson produced the cover layout using QuarkXPress 3.3 and the ITC Garamond font. Whenever possible, our books use RepKover, a durable and flexible lay-flat binding. If the page count exceeds RepKover's limit, perfect binding is used.
Alicia Cech designed the interior layout based on a series design by Nancy Priest. It was implemented in FrameMaker 5.5 by Mike Sierra. The text and heading fonts are ITC Garamond Light and Garamond Book. The illustrations that appear in the book were produced by Robert Romano and Rhon Porter using Macromedia FreeHand 8 and Adobe Photoshop 5. This colophon was written by Clairemarie Fisher O'Leary.
Oracle8i Internal Services for Waits, Latches, Locks and Memory Review
By Bob Stoneman
Comments about oreilly Oracle 8i Internal Services:
This is a book which I was craving information about. It has inspired me to take the Oracle8i Data Server internals class as an independent consultant. I can only aspire to be a true Oracle Guru like Steve Adams.