Database Management White Papers
Perfect Pitch
Overview The ability to analyze and correct Oracle Database physical read wait events is critical in any tuning project. The majority of activity in a database involves reading data, so this type of tuning can have a huge, positive impact on performance. System wait tuning has become very popular because it can show those wait events that are the primary bottleneck for the system. This paper explores a small subset of wait analysis, but it illustrates a critical concept of Oracle tuning: the fact that all Oracle databases wait on some kind of system resource, and it's the Oracle professional's job to determine whether the database is I/O bound, CPU bound, memory bound, or bound waiting on latches or locks.
| Publisher | Oracle | File Format | HTML |
|---|---|---|---|
| Date Published | October 2006 | ||
| Format | White Papers | ||
| Topics | |||



