Exam 1z0-054 topic 1 question 95 discussion

Actual exam question from Oracle's 1z0-054

Question #: 95
Topic #: 1

You work for ABC Pvt Ltd. The company has recently upgraded one of its development databases to Oracle Database 11g from Oracle Database 10g.
You noticed that the System Global Area (SGA) is undersized as shown in the Exhibit.
To investigate further, you checked the related parameters as shown below:
SQL> show parameter sga_max_size

NAME TYPE VALUE -
------------------------------ --------------- ----------------- sga_max_size big integer 500M

SQL> show parameter target -

NAME TYPE VALUE -
------------------------------ --------------- ------------------ archive_lag_target integer 0 db_flashback_retention_target integer 1440 fast_start_io_target integer 0 fast_start_mttr_target integer 0 memory_max_target big integer 0 memory_target big integer 0 pga_aggregate_target big integer 384M sga_target big integer 384M
Which is the best solution that you would recommend?

A. Increase the value of the SGA_MAX_SIZE parameter.
B. Set MEMORY_MAX_TARGET and MEMORY_TARGET parameters.
C. Reduce the value of the PGA_AGGREGATE_TARGET parameter.
D. Increase the value of both SGA_TARGET and PGA_AGGREGATE_TARGET parameters.
E. Diagnose further to identify which component in SGA is undersized and then resize it.

Show Suggested Answer

Suggested Answer: B 🗳️

by [deleted] at April 4, 2025, 8:42 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!