Which two options can help you get better database performance?

You have an Oracle database instance running on a Linux machine. By using the sar command, you observed that the page ins are increasing significantly, leading to degradation in database performance due to more I/O operations. Which two options can help you get better database performance? (Choose two.)

You have an Oracle database instance running on a Linux machine. By using the sar command, you observed that the page ins are increasing significantly, leading to degradation in database performance due to more I/O operations. Which two options can help you get better database performance? (Choose two.)

A.
Increase the swap space in the system.

B.
Enable the hugepages feature in the system.

C.
Set the LOCK_SGA parameter to TRUE for the database instance.

D.
Set FILESYSTEMIO_OPTION to NONE for the database instance.



Leave a Reply 1

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


mr_tienvu

mr_tienvu

I agree with the answer. BC