Oracle
1Z0-054 · Question #89
The users in your online transaction processing (OLTP) environment complain that the response time of the application has increased dramatically.To investigate the problem, view the Exhibit and…
The correct answer is E. The value set for the PGA_AGGREGATE_TARGET initialization parameter is too small. See the full explanation below for the reasoning.
Question
The users in your online transaction processing (OLTP) environment complain that the response time of the application has increased dramatically.To investigate the problem, view the Exhibit and examine the queries you executed.What do you infer?
Exhibit
Options
- ACursor sharing is not enabled.
- BThe large pool is not configured.
- CThe temporary tablespace is full.
- DThe value set for the SHARED_POOL_SIZE initialization parameter is too small.
- EThe value set for the PGA_AGGREGATE_TARGET initialization parameter is too small.
How the community answered
(37 responses)- A14% (5)
- B3% (1)
- C3% (1)
- D5% (2)
- E76% (28)
Community Discussion
No community discussion yet for this question.