You queried V$SYSTEM_EVENT in your online transaction processing (OLTP) environment to
check the following wait events:
Event Total Seconds Total Average Wait
Name Waits Waiting Timeouts (in secs)
—————————— ———— ——– ———— ———
direct path read temp 18,274 11,312 16,282 .619
direct path write temp 3,251 416 25 .127
What do these wait events indicate?
A.
The DBWn processes are not creating free buffers fast enough.
B.
The buffer cache is too small and block replacement is excessive.
C.
The aggressive checkpointing policy is causing too many writes to disk.
D.
The work areas are too large to fit in memory and are, therefore, written to disk.
the direct read/write temp wait is due to large working area and not fit into PGA. So it has to write to disk, but disk I/O may be slow
D is the right one.