 |
Oracle8i Internal Services for Waits, Latches, Locks, and Memory View Larger Image | Steve Adams
O'Reilly Media, Paperback, Published October 1999, ISBN 156592598X | List Price: $24.99
Our Price: $14.95
You Save: $10.04 (40% Off)
| | | Availability: Out-Of-Stock |
Customer Reviews: 5 Average Customer Rating:   Write a Review and tell the world about this title! People who purchase this book frequently purchase: Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
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.
Customer Reviews
Customer Reviews: 5 Average Customer Rating: Dec 12, 2002 Richard Handler from Perth, AU
Obsolete!
This book was OK years ago, but the Oracle internals have changed since Oracle8i. Also, much of the "internals" are not published by Oracle, and I found much obtuse speculation in this book.
Aug 23, 2001 Eugene from New York
Great book - a must for a serious DBA
This is one of the greatest books on Oracle i've ever seing. It is not a light reading - but gives one a tremendous insite into internals of Oracle. If you consider yourself a serious DBA, or on the road to become one - you MUST read it.
Jul 16, 2000 A review from Bangalore
The Best book i have ever seen for Oracle
This is the best book i have ever seen for oracle and the information provided in this book is really great, true and highly advacnced
Mar 21, 2000
Excellent Book for Oracle geeks
The best book i have seen for Oracle performance Tuning. Though the scope is very limited the author provides indepth information.More than that the author knows what he is speaking about.Not just reading the manuals and write a book.
Mar 22, 2000 Chip Dawes from Chicago
Great insight into the guts of Oracle
For not being an Oracle internals programmer, Steve has done an incredible job enlightening us on the internal workings that Oracle declines to reveal.
This book is not for beginners, and a must read for experts. Advanced database tuning requires the information Steve shares with us in this book.
|
|
