Oracle8i Internal Services
For Waits, Latches, Locks and Memory
Résumé
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.
L'auteur - Carlisle Adams
has been involved with the design, specification, and standardization of various aspects of public-key infrastructures for many years and is recognized internationally for his contributions in these areas. He has participated actively in the IETF Public-Key Infrastructure. Dr. Adams holds B.Sc. and M.Sc. degrees in computer science and a Ph.D. in Electrical Engineering. He is currently Senior Cryptographer and Senior Manager-Standards Program at Entrust Technologies.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | O'Reilly |
| Auteur(s) | Carlisle Adams |
| Parution | 10/10/1999 |
| Nb. de pages | 132 |
| EAN13 | 9781565925984 |
| ISBN13 | 978-1-56592-598-4 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
