Résumé
Poring over the 30 volumes of official Oracle documentation is a daunting task for any Oracle database administrator (DBA). Oracle8iTM Tuning and Administration: The Essential Reference distills the essentials of what you need to know to perform your job intelligently and skillfully. Bypassing obscure technical details, this book answers three essential questions for each topic listed below: What is it? Why is it important? How do I use it? Less experienced DBAs can now acquire the framework they need to understand important details in the Oracle documentation. Advanced DBAs will find this book a practical reference to effective configuration and troubleshooting. Oracle8iTM Tuning and Administration covers the major areas for which DBAs are typically responsible: administration, sizing and configuration, monitoring, and application and database tuning for better performance. In addition, the book reviews fundamental Oracle concepts and summarizes the newest features of Oracle8iTM. Specific topics covered include:
- Security and auditing
- Administering tables, views, constraints, indexes, data files, log files, and more
- Free space search algorithm
- Using database blocks efficiently
- Optimizing space management
- Partitioning
- Database, process, and object limits
- Monitoring events, usage, waits, and log files
- Query optimization hints
- SQL statement tuning
- Diagnosing performance problems and detecting runaway processes
- Tuning the operating system, CPU, memory, and disk I/O
- Tuning Private SQL and PL/SQL areas
- Tuning and initialization parameters
- New features for bitmapped indexes
- The new SAMPLE function
- Advanced queuing and sort improvements
- Online index creation, rebuild, and defragmentation
- Statistics generation for long-running operations
Concise and thorough, with an easy-access format, Oracle8iTM Tuning and Administration: The Essential Reference is the Oracle resource you will keep close at hand.
Contents
- Chapter 1: DBMS Concepts
- Chapter 2: Database Administration
- Chapter 3: Space Management within the database
- Chapter 4: Database Configuration
- Chapter 5: Database Monitoring
- Chapter 6: Application Tuning and Design
- Chapter 7: Tuning Database Performance
- Chapter 8: New Feature
L'auteur - Heidi Thorpe
Heidi Thorpe is a Senior DBA with a major financial institution in Melbourne, Australia. She has fifteen years of industry database experience with major international companies, and is a highly respected practitioner of database technologies.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Addison Wesley |
| Auteur(s) | Heidi Thorpe |
| Parution | 01/01/2001 |
| Nb. de pages | 590 |
| Format | 18,6 x 23,3 |
| Couverture | Broché |
| Poids | 1102g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780201704365 |
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
