You queried V$SYSTEM_EVENT in your online transaction processing (OLTP) environment to check the following wait events:E
Posted: Sun Jun 11, 2023 3:49 pm
You queried V$SYSTEM_EVENT in your online transaction processing (OLTP) environment to check the following wait events:Event Total Seconds Total Average WaitName Waits Waiting Timeouts (in secs)------------------------------ ------------ -------- ------------ --------- direct path read temp 18,274 11,312 16,282 .619 direct path write temp 3,251 416 25 .127What 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.
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.