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
Object (table and indexes) spent much of its In Oracle time on Buffer wait. This usually occurs as a result of one of the following:
Contention on a table or index buffer in Insert statements (Buffer Busy wait).
Lack of free buffer space when trying to load blocks from a disk (Free Buffer wait).
| Description | |
| What to do next | Perform the following options: n Examine buffer wait over time, in the Activity Workspace. n Examine buffer wait substate events in the Statistics workspace. |
| Advice | Perform one of the following options: If Buffer Busy wait is the more dominant Oracle event, consider doing the following: n Increase the free lists for the table to reduce the chances of contention. n Increase the PCTFREE parameter or decrease the block size for the table, to distribute data among many blocks and reduce the chances for contention. If Free Buffer wait is the more dominant Oracle event, consider doing the following: n Tune access to the object, in order to reduce the number of blocks fetched. n If the problem is a global instance problem, increase the number of DBWR processes or I/O slaves. |
No comments:
Post a Comment