High-Performance Oracle: Proven Methods for Achieving Optimum Performance and Availability
Proven methods for achieving Optimum performance and availability
Résumé
Ensuring high-performance and continuous availability of Oracle software is a key focus of database managers. At least a dozen books address the subject of "performance tuning"–– that is, how to fine-tune the Oracle database for its greatest processing efficiency. Geoff Ingram argues that this approach simply isn’t enough. He believes that performance needs to be addressed right from the design stage, and it needs to cover the entire system––not just the database.
High-Performance Oracle is a hands-on book, loaded with tips and techniques for ensuring that the entire Oracle database system runs efficiently and doesn’t break down. Written for Oracle developers and DBAs, and covering both Oracle8i and Oracle9i, the book goes beyond traditional performance-tuning books and covers the key techniques for ensuring 24/7 performance and availability of the complete Oracle system.
The book provides practical solutions for:
- Choosing physical layout for ease of administration and efficient use of space
- Managing indexes, including detecting unused indexes and automating rebuilds
- SQL and system tuning using the powerful new features in Oracle9i Release 2
- Improving SQL performance without modifying code
- Running Oracle Real Application Clusters (RAC) for performance and availability
- Protecting data using Recover Manager (RMAN), and physical and logical standby databases
The companion Web site provides the complete source code for examples in the book, updates on techniques, and additional documentation for optimizing your Oracle system.
Author Biography: GEOFF INGRAM has spent his entire career in the IT industry, including several years working as a product developer at Oracle Corporation. Since leaving Oracle, he has operated as a freelance consultant for blue chip companies in the banking and telecommunication sectors. He focuses on delivering Oracle systems that meet end-user performance and availability requirements, and has developed a free software application for fine-tuning Oracle applications.
Contents- Pt. 1 Fundamentals of an Oracle Configuration
- Ch. 1 Installing Oracle
- Ch. 2 Database Creation
- Ch. 3 Configuring Oracle Networking
- Ch. 4 Environment Standards and Tools
- Ch. 5 Securing Your Database
Pt. 2 Designing Fast and Supportable Applications
- Ch. 6 Designing Supportable Applications
- Ch. 7 Choosing Third-Party Software
Pt. 3 Performance Management and Tuning Techniques
- Ch. 8 End-to-End Performance Management
- Ch. 9 Fundamentals of SQL Tuning
- Ch. 10 Collecting and Using Optimizer Statistics
- Ch. 11 Partitioning
- Ch. 12 Managing Indexes
- Ch. 13 Managing Space Growth
- Ch. 14 Stress Testing and Benchmarks
- Ch. 15 Server Consolidation and Resource Management
- Ch. 16 Selecting and Using Performance Management Tools
Pt. 4 Backup, Restore, and Recovery
- Ch. 17 Fundamentals of Oracle Recovery
- Ch. 18 Backup and Recovery Using Recovery Manager (RMAN)
- Ch. 19 Backup and Restore Using Export and Import
Pt. 5 High Availability (HA) Solutions
- Ch. 20 VERITAS High Availability (HA) for Oracle
- Ch. 21 Oracle Replication
- Ch. 22 Oracle Real Application Clusters
- Ch. 23 Protecting Data Using Standby Databases
Pt. 6 Maintaining the Oracle System
- Ch. 24 Guidelines for Health Checks and Monitoring
- Ch. 25 Auditing Techniques
- Ch. 26 Migration and Upgrade
- Ch. 27 Working Effectively with Oracle Support
- Ch. 28 Troubleshooting Oracle DBMS Problems
L'auteur - Geoff Ingram
GEOFF INGRAM has spent his entire career in the IT
industry, including several years working as a product
developer at Oracle Corporation. Since leaving Oracle, he
has operated as a freelance consultant for blue chip
companies in the banking and telecommunication sectors. He
focuses on delivering Oracle systems that meet end-user
performance and availability requirements, and has
developed a free software application for fine-tuning
Oracle applications.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Wiley |
| Auteur(s) | Geoff Ingram |
| Parution | 16/10/2002 |
| Nb. de pages | 684 |
| Format | 19 x 23,5 |
| Couverture | Broché |
| Poids | 1250g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780471224365 |
| ISBN13 | 978-0-471-22436-5 |
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
