How does one tune Oracle Wait events?

Here are some of the wait events from V$SESSION_WAIT and V$SYSTEM_EVENT views:

• db file sequential read: Tune SQL to do less I/O. Make sure all objects are analyzed. Redistribute I/O across disks.

• buffer busy waits: Increase DB_CACHE_SIZE (DB_BLOCK_BUFFERS prior to 9i)/ Analyze contention from SYS.V$BH

• log buffer space: Increase LOG_BUFFER parameter or move log files to faster disks