Oracle
1Z0-054 · Question #95
1Z0-054 Question #95: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #95. The question stem and answer options stay visible for context.
Question
You are working on a 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. 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 the SGA depending on the workloads. Which two options would solve this problem? (Choose two.)
Exhibit
Options
- ASet the SGA_TARGET parameter to 300M.
- BSet the SGA_MAX_SIZE parameter to 400M.
- CSet the MEMORY_MAX_TARGET and MEMORY_TARGET parameters to 400M.
- DSet the MEMORY_MAX_TARGET and MEMORY_TARGET parameters to 100M.
- ESet the PGA_AGGREGATE_TARGET parameter to 200M and the SGA_MAX_SIZE parameter to
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.