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.

http://www.dbspecialists.com/presentations/wait_events2.html

Complement information: (small guide)

http://www.perfvision.com/waits.php

Instance Tuning Using Performance Views

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

http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/instance_tune.htm

Blog at WordPress.com.