Question: I need to learn how to eliminate
Oracle Wait Events and I understand that you can tune to remove
Oracle Wait Events. What are the steps to tune Oracle wait events?
Answer: Oracle Wait Events are conditions
where a session is waiting for something to happen. A wait event
can be caused by many things, from slow read/write speeds on the
disk, to locking situations caused by the architecture, to various
kinds of Oracle contentions. Waits are either system-level or
session-level. A session-level wait event is an event that affects
a single user activity within the database. System-level wait
events affect the entire database system.
For more information on tuning oracle wait events, the following
pages will be helpful:
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.