Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Your instance has spent much of its In Oracle time waiting for database buffers.
| Description | |
| What to do next | Perform one of the following options: n Examine the Oracle events that are grouped in the Buffer Wait. Determine the dominant Oracle event and follow the tuning scenario set by this event in the Statistics workspace. n If the dominant Oracle event is buffer busy, launch into the Activity workspace and locate the objects with the highest buffer wait. |
| Advice | There are two typical scenarios relevant to buffer wait that are determined by the dominant Oracle event: n Buffer Busy wait event There is high contention on specific table blocks. To reduce contention, increase the Freelists or the Pctfree for the table. n Free Buffer Wait event There are no available buffers in the buffer cache. This is usually an I/O wait related problem. Do the following: Try and tune the heaviest statements or objects. If this event persists after statement tuning, try and increase DBWR throughput by adding more DBWR processes or DBWR_I/O_SLAVES. Increase the buffer cache size. |
No comments:
Post a Comment