Oracle8i™ Tuning and Administration: The Essential Reference - Couverture souple

Thorpe, Heidi

Couverture souple

ISBN 10 : 0201704366 ISBN 13 : 9780201704365

Editeur : Addison Wesley, 2000

Synopsis

Book by Thorpe Heidi

A propos du livre

Quatrième de couverture :

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.

Biographie de l'auteur :

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.

0201704366AB04062001

À propos de cette édition

• Éditeur: Addison Wesley
• Date d'édition: 2000
• ISBN 10: 0201704366
• ISBN 13: 9780201704365
• Reliure: Broché
• Nombre de pages: 608