Oracle Performance Tuning - Softcover

Whalen, Edward; Schroeter, Mitchell

Softcover

ISBN 10: 0672321467 ISBN 13: 9780672321467

Publisher: Addison Wesley, 2002

Synopsis

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.

About this title

About the Author

Edward Whalen is vice president and founder of Performance Tuning Corporation (http://www.perftuning.com), a consulting company that specializes in database performance, administration, and backup/recovery solutions. He has extensive experience in database system design and tuning for optimal performance. His career has consisted of hardware, operating system, and database development projects for many different companies. Edward has published two other books on the Oracle RDBMS. He has also written four books on Microsoft SQL Server. In addition to writing, Edward has worked on numerous benchmarks and performance-tuning projects with both Oracle and MS SQL Server.

Mitchell Schroeter is a senior consultant with Performance Tuning Corporation (http://www.perftuning.com) and has worked in the field of database performance tuning for five years. Prior to Performance Tuning Corporation, Mitchell worked at Dell Computer Corporation as a systems analyst in the systems performance analysis group, specializing in database technologies and high-performance storage systems. He has extensive experience with developing client-server and multitiered applications on both Oracle and Microsoft SQL Server in a variety of programming languages. Mitchell specializes in tuning database systems and application code, storage area networks, and Oracle 9i Real Application Clusters.

0672321467AB04222002

Edition details

• Publisher: Addison Wesley
• Publication date: 2002
• ISBN 10: 0672321467
• ISBN 13: 9780672321467
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 432