Oracle
1Z0-064 · Question #80
Examine the parameters set for a database instance: The database supports a mixed workload. Users complain about the increased response time of a few DSS queries. During investigation, you execute…
The correct answer is B. Enable Automatic Memory Management. F. Increase the value of the PGA_AGGREGATE_TARGET parameter. See the full explanation below for the reasoning.
Question
Examine the parameters set for a database instance:
The database supports a mixed workload. Users complain about the increased response time of a few DSS queries. During investigation, you execute the query:
Based on the output, which two are possible ways to improve the performance of the queries? (Choose two.)
Exhibits
Options
- AEnable temporary undo.
- BEnable Automatic Memory Management.
- CIncrease the number of DBWn processes.
- DEnable Automatic Shared Memory Management.
- EIncrease the value of the SGA_TARGET parameter.
- FIncrease the value of the PGA_AGGREGATE_TARGET parameter.
How the community answered
(36 responses)- A3% (1)
- B75% (27)
- C14% (5)
- D3% (1)
- E6% (2)
Community Discussion
No community discussion yet for this question.