Oracle
1Z0-054 · Question #88
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 correct answer is C. Increase the size of PGA to 160 MB or more. See the full explanation below for the reasoning.
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.
How the community answered
(31 responses)- A6% (2)
- B3% (1)
- C77% (24)
- D13% (4)
Community Discussion
No community discussion yet for this question.

