Oracle Performance Tuning

Edward Whalen, Mitchell Schroeter

414 pages, parution le 07/05/2002

Ajouter à une liste

Indisponible

Résumé

Learn how to diagnose performance problems, and how to improve and optimize an Oracle Database.

This book covers hardware as well as software issues. This is unique to many of the Oracle performance books that only cover software issues.
The reader will be trained in proper Developer application development from the user and the performance point of views.
Covers Oracle9I--the latest version of Oracle.

This book is designed to enhance the skills of the Oracle DBA by giving them knowledge and examples on how to improve their system's performance. Readers will learn how to: understand how to use trace files, the alert log file and event sets to assist with tuning; become familiar with the new features of Oracle9i.; understand and be able to use utilities and dynamic performance views to assist with tuning; understand how to tune applications using index structures and how to perform SQL statement tuning.; tune SQL Statements Efficiently; read Alert Logs and Trace Files; tune the Shared Pool; tune the Buffer Cache; use Multiple Buffer Caches; tune a Multi-Threaded Server; configure and tune the storage subsystem that Oracle is using, and use Oracle in a SAN environment.

Contents

1 : Instance Tuning
- Tuning fundamentals
- Using the Oracle configuration parameters
- Tuning the Oracle instance
- Performance-enhancing features
- Tuning workloads
- The Oracle performance views
- Using UTLBSTAT and UTLESTAT
2 : Oracle hardware topics
- Oracle and system hardware
- I/O concepts
- Oracle and I/O
3 : Application and SQL tuning
- Using EXPLAIN PLAN and SQL trace
- Index tuning
- The Oracle optimizer
- Tuning SQL
- Using hints
4 : Advanced topics
- Oracle9i real application clusters
- Tuning backup and recovery
- Creating a high-performance disaster survival system
- Oracle networking performance
Index

Caractéristiques techniques

	PAPIER
Éditeur(s)	Addison Wesley
Auteur(s)	Edward Whalen, Mitchell Schroeter
Parution	07/05/2002
Nb. de pages	414
Format	19 x 23,5
Couverture	Broché
Poids	711g
Intérieur	Noir et Blanc
EAN13	9780672321467
ISBN13	978-0-672-32146-7

Avantages Eyrolles.com

Livraison à partir de 0,01 € en France métropolitaine

Paiement en ligne SÉCURISÉ

Livraison dans le monde

Retour sous 15 jours

+ d'un million et demi de livres disponibles

Oracle Performance Tuning

Résumé

Caractéristiques techniques

Consultez aussi