Oracle8i™ Tuning and Administration: The Essential Reference - Softcover

Thorpe, Heidi

Softcover

ISBN 10: 0201704366 ISBN 13: 9780201704365

Publisher: Addison Wesley, 2000

Synopsis

Oracle 8i Tuning and Administration: The Essential Reference is the most practical, efficient guide to Oracle 8i administration and tuning. Senior DBA Heidi Thorpe presents real-world problems, clear solutions, and the concepts behind them, giving DBAs the insights they need to understand why things work the way they do -- so they can make intelligent judgments, not simply follow "cookie-cutter" instructions. Oracle 8I Tuning and Administration begins with detailed solutions for day-to-day database administration: administering tables, constraints, indexes, datafiles, views, sequences, rollback segments, tablespaces, users, and more. Thorpe addresses the up-front database design issues that impact manageability and performance; offers extensive coverage of new Oracle 8i features; and reviews both database engine and application optimization in depth. The book also offers real-world insight and practical guidance for database sizing, monitoring, and space management. For all Oracle database administrators and managers responsible for supervising the day-to-day operations of Oracle databases and database-enabled Web sites.

About this title

About the Author

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

From the Back Cover

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.

Edition details

• Publisher: Addison Wesley
• Publication date: 2000
• Language: English
• ISBN 10: 0201704366
• ISBN 13: 9780201704365
• Binding: Paperback
• Number of pages: 608