Oracle
1Z0-054 · Question #99
1Z0-054 Question #99: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #99. The question stem and answer options stay visible for context.
Question
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?
Exhibit
Options
- AIncrease the value of the SGA_MAX_SIZE parameter.
- BSet MEMORY_MAX_TARGET and MEMORY_TARGET parameters.
- CReduce the value of the PGA_AGGREGATE_TARGET parameter.
- DIncrease the value of both SGA_TARGET and PGA_AGGREGATE_TARGET parameters.
- EDiagnose further to identify which component in SGA is undersized and then resize it.
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.