BackCover

Back Cover

Troubleshoot, diagnose, and optimize your Oracle database efficiently and successfully every time. This exclusive Oracle Press guide explains how to take full advantage of the revolutionary Oracle Wait Interface (OWI) to quickly pinpoint ‚ and solve ‚ core problems and bottlenecks and increase productivity exponentially. Get extensive details on all the OWI features, including the wait event views and their applications, and the extended SQL trace file. This invaluable resource will help you to maximize the most advanced diagnostics tool available and minimize processing time.

• Identify performance problems using wait event statistics
• Monitor session-level wait events and collect historical data for root cause analysis
• Interpret common I/O- related wait events
• Diagnose and solve problems related to locking and serialization
• Analyze latency-related wait events
• Identify and resolve bottlenecks in the Oracle Real Application Clusters environment
• Learn about the Oracle Database 10g revolutionary approach to performance diagnostics and tuning

About the Authors

Richmond Shee is a Senior Database Architect for Sprint Corporation, a global integrated communications provider serving more than 26 million customers in over 100 countries . Richmond has worked with relational databases since 1984. He mentors DBAs and helps set the direction for implementing Oracle RDBMS technology throughout the company. Richmond leads the tuning efforts on all of Sprint ‚ s most critical databases. Among his many accomplishments is pioneering the use of the Oracle Wait Interface at Sprint. He also invented a patent-pending wait-based performance data collector. He is a recognized presenter at the International Oracle Users Group , and he speaks frequently at the Kansas City OUG.

Kirtikumar Deshpande (Kirti) has been working in the information technology field for over 24 years, including more than 10 years as an Oracle Database Administrator. He holds Bachelor of Science (Physics) and Bachelor of Engineering (Bio-Medical) degrees. He co- authored an Oracle Press book titled Oracle Performance Tuning 101 , published in May 2001. He has presented papers in the local Oracle user group meetings and at national and international Oracle user group conferences. He currently works for Verizon Information Services as a Senior Oracle Database Administrator.

K Gopalakrishnan (Gopal) is a Principal Consultant with Oracle Solution Services (India), specializing exclusively in performance tuning, high availability, and disaster recovery. He is a recognized expert in Oracle RAC and Database Internals and has used his extensive expertise in solving many vexing performance issues all across the world for telecom giants, banks, and universities. He is also a prolific writer and frequently publishes articles in the Oracle Internals journal. He has more than eight years of experience backed by a degree in Computer Science and Engineering from the University of Madras, India.