Skip to content

Oracle 8i Internal Services For Waits, Latches, Locks, and Memory

Best in textbook rentals since 2012!

ISBN-10: 156592598X

ISBN-13: 9781565925984

Edition: 1999

Authors: Steve Adams, Debby Russell

List price: $24.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

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…    
Customers also bought

Book details

List price: $24.99
Copyright year: 1999
Publisher: O'Reilly Media, Incorporated
Publication date: 11/16/1999
Binding: Paperback
Pages: 132
Size: 5.98" wide x 9.02" long x 0.39" tall
Weight: 0.484
Language: English

Preface
Introduction
The Oracle Kernel Layers
The Kernel Services
Waits
Semaphores
Wait Statistics
Reference
Latches
Latches and Locks
Parent and Child Latches
Latch Gets
Advanced Latching Control
Reference
Locks
Lock Usage
Lock Modes
Enqueue Locks
Row Cache Enqueues
Library Cache Locks and Pins
DML Locks
Buffer Locks
Sort Locks
Reference
Instance Locks
The Lock Manager
Global Locks
PCM Instance Locks
Other Instance Locks
Reference
Memory
The SGA
The Shared Pool
Process Memory
Reference
Index