QUESTION 197- read blocks/ read blocks

Examine the portition of this Active Session History (ASH) report that is marked with a red rectangle:

Activity Over Time

Analysis period is devided into smaller time slots

Top 3 events are reported in each of those slots

"Slot Count" shows the number of ASH sampels in that slot

"Event Count" shows the number of ASH samples waiting for that event is that slot

"%Event" is "Event Count" over all ASH samples in analysis period

Slot Time(Duration) Slot Count Event Event Count %Event

--------------------------------------------------------------------------------------------------------------------------------------------- ---------------

17:13:00(1.0min) 6 CPU+Wait for CPU 6 0.25

--------------------------------------------------------------------------------------------------------------------------------------------- ---------------

17:14:00(1.0min) 634 buffer busy waits 590 24.67

CPU+Wait for CPU 32 1.34

log file sync 7 0.29

--------------------------------------------------------------------------------------------------------------------------------------------- ---------------

17:15:00(1.0min) 1752 buffer busy waits 1623 67.85 (red)

CPU+Wait for CPU 61 2.55 (red)

Cursor:pin S 46 1.92 (red)

Which two inferences can be drawn from the report?

A. Sessions attempting to read blocks images in the buffer cache are waiting while other sessions are modifying the same block images.

B. Sessions attempting to modify blocks images in the buffer cache are waiting while other sessions are reading the same block images.

C. Sessions are waiting for writes of modified block images in the buffer cache to complete.

D. Sessions attempting to read blocks images in the buffer cache are waiting while other sessions are reading the same block images.

E. Sessions are warting to find free buffer cache.

Correct Answer: AC

Buffer busy waits 等待事件产生的原因，就是块争用。

B： 错误。一个块正在被其他进程读取的时候，另外的进程是可以修改的（undo）

D：错误。 读与读互相不影响 （除非大量的进程同时全表扫描的时候，容易引起latch 共享锁等待）

E： 错误。 这个应该是 free buffer waits 等待才对。