Przegląd interesujących książek z dziedziny informatyki

Steve Adams:

Oracle8i Internal Services for Waits, Latches, and Memory

O'Reilly & Associates, 1999, ISBN 1-56592-598-X
120 pages

The book provides a reader with the information on Oracle8i (rel. 8.1) internal services. The book is aimed at advanced database administrators and contains the information on advanced tuning of an Oracle database instance.

The book covers in details the following subjects. Chapter 1 overviews Oracle kernel layers and services. Chapter 2 discusses communication between Oracle processes by means of semaphores, wait types, and parameters, as well as various statistics concerning processes and waits. Chapter 3 covers the mechanism of latches and locks, as well as data dictionary structures making available the relevant information. Chapter 4 is a complete source of information on locking concept, locking mechanism, locking types, deadlock detection and resolution, and data dictionary structures on locks. Chapter 5 describes inter-instance communication and locking in Oracle parallel server architecture. Chapter 6 describes the structure and management of an Oracle instance memory - SGA as well as memory structures used by Oracle processes. Various statistics on discussed concepts are also presented.

The advantage of "Oracle8i Internal Services" lies in its concise content, written in a straightforward manner. The book is a complete source of information on advanced tuning of an Oracle instance and processes.

wróć