Oracle
1Z0-054 · Question #88
1Z0-054 Question #88: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #88. The question stem and answer options stay visible for context.
Question
The users in your online transaction processing (OLTP) environment complain that the query response time has increased considerably. You checked the Program Global Area (PGA)- related information in the AWR report to investigate it further. View the Exhibit named PGAHIT and note the PGA cache-hit percentage. View the Exhibit named PGAADV and analyze the content. If you want to increase the size of PGA, you have sufficient memory available in the system. What would be the correct decision?
Exhibits
Options
- ADouble the size of PGA.
- BIncrease the size of PGA to 120 MB.
- CIncrease the size of PGA to 160 MB or more.
- DLeave the PGA at its current size and investigate other possible causes.
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.