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 0

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