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 statement has spent much of its In Oracle time on Buffer Wait.
This usually occurs because one of two possible scenarios:
Contention on a table buffer in Insert statements (Buffer Busy Wait), or
Lack of free buffers when trying to load blocks from a disk (Free Buffer Wait)
| Description | |
| What to do next | Perform one of the following options: n Select the findings type to identify the tables suffering from Buffer Wait in the Objects tab, or n Examine Buffer Wait sub-state events in the Statistics workspace. |
| Advice | When Buffer Busy Wait is the more dominant Oracle event, consider the following options: n Increase the free lists for the table to reduce the chances for contention. n Increase the PCTFREE parameter or decrease the block size for the table in order to spread the data among many blocks and reduce the chances for contention. When Free Buffer Wait is the more dominant Oracle event, consider the following options: n Tune the object's access, so as to reduce the number of blocks fetched. n If this is a global instance problem, increase the number of DBWR processes or I/O slaves. |
No comments:
Post a Comment