831. How does one tune Oracle Wait events? (for DBA
Event Name:
|
Tuning Recommendation:
|
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 spaces
|
Increase LOG_BUFFER parameter or move log files to faster disks
|