Oracle
1Z0-064 · Question #55
You are administering a database that supports a DSS workload. Automatic Shared Memory Management is enabled for the database instance. Users issue queries to perform large soft operations and…
The correct answer is B. Increase the value of the PGA_AGGREGATE_TARGET parameter. C. Create a temporary tablespace group and assign it to users. See the full explanation below for the reasoning.
Question
You are administering a database that supports a DSS workload. Automatic Shared Memory Management is enabled for the database instance. Users issue queries to perform large soft operations and complain about degraded performance of the queries. On investigation, you notice that the queries are performing multipass work area executions and the I/O contention on one of the temporary tablespaces is very high. Which two can be possible resolutions for this issue? (Choose two.)
Options
- AIncrease the size of the large pool.
- BIncrease the value of the PGA_AGGREGATE_TARGET parameter.
- CCreate a temporary tablespace group and assign it to users.
- DIncrease the value of the PGA_AGGREGATE_LIMIT parameter.
- ECreate another temporary tablespace and assign it to users.
- FEnable temporary undo.
How the community answered
(25 responses)- A16% (4)
- B72% (18)
- D8% (2)
- F4% (1)
Community Discussion
No community discussion yet for this question.