Which step would be appropriate to improve the performance?

You queried V$SYSTEM_EVENT in your online transaction processing (OLTP) environment to
check the following wait events:
Average
Event Total Seconds Total 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
Which step would be appropriate to improve the performance?

You queried V$SYSTEM_EVENT in your online transaction processing (OLTP) environment to
check the following wait events:
Average
Event Total Seconds Total 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
Which step would be appropriate to improve the performance?

A.
Increase the number of I/O slaves.

B.
Increase the size of the Database Buffer Cache.

C.
Increase the size of the Program Global Area (PGA).

D.
Increase the number of database writer (DBWn) processes.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

direct path operation is in PGA

C is right.