Friday, July 27, 2012

How to interpretate wait events to troubleshoot production problems

  • Wait events touch all areas of Oracle—from I/O to latches to parallelism to network traffic
  • Wait event data can be remarkably detailed. “Waited 0.05 seconds to read 15 blocks from file 15 starting at block 25008.”
  • Analyzing wait event data will yield a path toward a solution for almost any problem
  • The wait event interface gives you access to a detailed accounting of how Oracle processes spend their time.
  • Wait events touch all aspects of the Oracle database server.
  • The wait event interface will not always give you the answer to every performance problem, but it will just about always give you insights that guide you down the proper path to problem resolution.

No comments:

Post a Comment