Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How does one tune Oracle Wait event XYZ?

April 26, 2017event Oracle tune wait XYZ

0

Posted

How does one tune Oracle Wait event XYZ?

1 Answer

0

Posted

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 (“buffer busy waits” was replaced with “read by other session” Oracle 10g). • log buffer space: Increase LOG_BUFFER parameter or move log files to faster disks • log file sync: If this event is in the top 5, you are committing too often (talk to your developers) • log file parallel write: deals with flushing out the redo log buffer to disk. Your disks may be too slow or you have an I/O bottleneck.