High-Performance Oracle (eBook)
720 Seiten
John Wiley & Sons (Verlag)
978-0-471-43034-6 (ISBN)
process of managing Oracle performance. This book can support every
technical person looking to resolve Oracle8i and Oracle9i
performance issues."
-Aki Ratner, President, Precise Software Solutions
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.
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, available from www.dbcool.com.
Dedication.
Acknowledgements.
Introduction.
PART ONE: FUNDAMENTALS OF AN ORACLE CONFIGURATION.
Chapter 1- Installing Oracle.
Chapter 2- Database Creation.
Chapter 3- Configuring Oracle Networking.
Chapter 4- Environment Standards and Tools.
Chapter 5- Securing your Database.
PART TWO: DESIGNING FAST AND SUPPORTABLE APPLICATIONS.
Chapter 6- Designing Supportable Applications.
Chapter 7- Choosing Third Party Software.
PART THREE: PERFORMANCE MANAGEMENT AND TUNING TECHNIQUES.
Chapter 8- End-to-End Performance Management.
Chapter 9- Fundamentals of SQL Tuning.
Chapter 10- Collecting and Using Optimizer Statistics.
Chapter 11- Partitioning.
Chapter 12- Managing Indexes.
Chapter 13- Managing Space Growth.
Chapter 14- Stress Testing and Benchmarks.
Chapter 15- Server Consolidation and Resource Management.
Chapter 16- Selecting and Using Performance Management Tools.
PART FOUR: Backup, Restore, and Recovery.
Chapter 17- Fundamentals of Oracle Recovery.
Chapter 18- Backup and Recovery Using RMAN.
Chapter 19- Backup and Restore Using Export and Import.
PART FIVE: HIGH AVAILABILITY SOLUTIONS.
Chapter 20- VERITAS High Availability for Oracle.
Chapter 21- Oracle Replication.
Chapter 22- Oracle Real Application Clusters.
Chapter 23- Protecting Data Using Standby Databases.
PART SIX: Maintaining the Oracle System.
Chapter 24- Guidelines for Healthchecks and Monitoring.
Chapter 25- Auditing Techniques.
Chapter 26- Migration and Upgrade.
Chapter 27- Working Effectively with Oracle Support.
Chapter 28- Troubleshooting Oracle DBMS Problems.
Index.
| Erscheint lt. Verlag | 15.10.2002 |
|---|---|
| Sprache | englisch |
| Themenwelt | Informatik ► Datenbanken ► Oracle |
| Mathematik / Informatik ► Informatik ► Netzwerke | |
| Schlagworte | Computer Science • Database & Data Warehousing Technologies • Datenbank • Datenbanken u. Data Warehousing • Datenbankverwaltung • Informatik • ORACLE (Datenbanksystem) |
| ISBN-10 | 0-471-43034-X / 047143034X |
| ISBN-13 | 978-0-471-43034-6 / 9780471430346 |
| Haben Sie eine Frage zum Produkt? |
PDF (Adobe DRM)Größe: 2,8 MB
Kopierschutz: Adobe-DRM
Adobe-DRM ist ein Kopierschutz, der das eBook vor Mißbrauch schützen soll. Dabei wird das eBook bereits beim Download auf Ihre persönliche Adobe-ID autorisiert. Lesen können Sie das eBook dann nur auf den Geräten, welche ebenfalls auf Ihre Adobe-ID registriert sind.
Details zum Adobe-DRM
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen eine
Geräteliste und zusätzliche Hinweise
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
