OCP CBT Question 542

Please solve the following question.

You are reviewing the V$SGA_TARGET_ADVICE view to optimize your database's memory configuration. Examine the following excerpt from the view:Based on this output, what is the most appropriate recommendation for SGA_TARGET?

SGA Target AdviceSGA_SIZE_FACTOR SGA_SIZE SGA_SIZE_ESTD_MB ESTD_DB_TIME_FACTOR ESTD_PHYSICAL_READS_FACTOR--------------- -------- ---------------- ------------------- -------------------------- .5 40960 40000 1.50 2.00 1.0 81920 80000 1.00 1.00 1.5 122880 120000 .95 .90 2.0 163840 160000 .94 .89The current SGA_TARGET is 80GB (represented by SGA_SIZE_FACTOR 1.0). ESTD_DB_TIME_FACTOR represents the estimated DB time relative to the current DB time, and ESTD_PHYSICAL_READS_FACTOR represents estimated physical reads relative to current physical reads.

Decrease SGA_TARGET to 40GB to reduce memory consumption, as the ESTD_DB_TIME_FACTOR is only 1.50.

Maintain SGA_TARGET at 80GB, as increasing it further provides minimal performance benefits.

Increase SGA_TARGET to 120GB, as it shows a significant reduction in ESTD_DB_TIME_FACTOR and ESTD_PHYSICAL_READS_FACTOR.

Increase SGA_TARGET to 160GB for the maximum performance gain.