Oracle Waits Defined

Buffer Cache

Cache Buffers Chains latch
Cache Buffers lru Chain latch
Free Buffer Waits
Write Complete Waits

I/O

Buffer Busy
Db file sequential read
Db file scattered read
Db file parallel read
Direct path read
Direct path write
File open
File identify

Library Cache

Library Cache latch
Shared Pool latch
Library Cache Lock
Library Cache Load Lock
Library Cache Pin
Row Cache Lock

Locks
Redo

log buffer space
Log file Sync
Log file switch completion
log file switch (checkpoint incomplete)
log file switch (archiving needed)

SQL*Net and others

SQL*Net more data from client
SQL*Net more data to client
SQL*Net break/reset to client
SQL*Net break/reset to dblink