Buying Options
Oracle Internals: An Introduction
Print $24.99
Add to Cart
Safari Books Online
Add to Cart
What is this?
Print £18.99
Add to Cart
What is this?
Description

Based on Oracle8i, release 8.1, this concise book contains detailed, hard-to-find information about Oracle internals (data structures, algorithms, hidden parameters, and undocumented system statistics), Main topics include waits, latches, locks (including instance locks used in parallel server environments), and memory use and management. Aimed especially at readers doing advanced performance tuning

Full Description
Table of Contents
  1. Chapter 1 Introduction

    1. The Oracle Kernel Layers

    2. The Kernel Services

  2. Chapter 2 Waits

    1. Semaphores

    2. Wait Statistics

    3. Reference

  3. Chapter 3 Latches

    1. Latches and Locks

    2. Parent and Child Latches

    3. Latch Gets

    4. Advanced Latching Control

    5. Reference

  4. Chapter 4 Locks

    1. Lock Usage

    2. Lock Modes

    3. Enqueue Locks

    4. Row Cache Enqueues

    5. Library Cache Locks and Pins

    6. DML Locks

    7. Buffer Locks

    8. Sort Locks

    9. Reference

  5. Chapter 5 Instance Locks

    1. The Lock Manager

    2. Global Locks

    3. PCM Instance Locks

    4. Other Instance Locks

    5. Reference

  6. Chapter 6 Memory

    1. The SGA

    2. The Shared Pool

    3. Process Memory

    4. Reference

  1. Colophon

View Full Table of Contents
Product Details
Title:
Oracle Internals: An Introduction
By:
Steve Adams
Publisher:
O'Reilly Media
Formats:
  • Print
  • Safari Books Online
Print Release:
October 1999
Pages:
136
Print ISBN:
978-1-56592-598-4
| ISBN 10:
1-56592-598-X
Customer Reviews
About the Author
  1. Steve Adams

    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 steve.adams@ixora.com.au or via his company's web site at http://www.ixora.com.au/.

    View Steve Adams's full profile page.

Colophon

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.

  • Book cover of Oracle Internals:  An Introduction