Exam 1z0-054 topic 1 question 5 discussion

Actual exam question from Oracle's 1z0-054

Question #: 5
Topic #: 1

You are working on a development database that was upgraded to Oracle Database 11g from Oracle Database 9i. An ADDM finding in this database says that the shared pool is inadequately sized, as shown in the Exhibit.

You diagnosed that this is due to different kinds of workloads and this occurs only during peak hours. You tried to resize this by shrinking the database buffer cache but that caused inadequate buffer cache problems. The following are the related parameter settings:

SQL> show parameter sga -

NAME TYPE VALUE -
------------------------------ --------------- ----------------- lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 300M sga_target big integer 0

SQL> show parameter target -

NAME TYPE VALUE -
------------------------------ --------------- -----------------
.....
fast_start_mttr_target integer 0
memory_max_target big integer 0
memory_target big integer 0
pga_aggregate_target big integer 100M
sga_target big integer 0
You want to balance the memory between the System Global Area (SGA) components within SGA without affecting the size of the Program Global Area (PGA).
Which action would solve this problem?

A. Set the SGA_TARGET parameter to 300M.
B. Set the SGA_MAX_SIZE parameter to 400M.
C. Set the MEMORY_TARGET parameter to 100M.
D. Set the MEMORY_MAX_TARGET parameter to 300M.

Show Suggested Answer

Suggested Answer: A 🗳️

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

Comments

Submit Cancel

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