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:
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
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:
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
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 0

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