Oracle Logbook

September 12, 2007

Interpreting Wait Events to Boost System Performance

Filed under: Uncategorized — Helio Dias @ 3:07 pm

by Roger Schrag and Terry Sutton In early 2002 Roger Schrag published a paper entitled, “Interpreting Wait Events to Boost System Performance.” That paper began with a definition of wait events and techniques for collecting wait event information, and then went on to discuss four examples of how wait event data had been used to solve real-life performance problems. The impetus for writing that paper had been that, while many resources were available that listed the wait event v$ views, we were not aware of any publication that used real-life examples to demonstrate how to use the wait event interface to solve problems or boost system performance.

Complement information: (small guide)

Instance Tuning Using Performance Views

Filed under: Uncategorized — Helio Dias @ 2:27 pm

Blog at