Oracle
1Z0-063 · Question #172
Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot…
The correct answer is D. Enable Automatic Memory Management (AMM). E. Increase the size of the temporary tablespace. See the full explanation below for the reasoning.
Question
Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention. Which two actions would you take to solve this problem?
Options
- AEnable temporary undo for the database.
- BEnable undo retention guarantee.
- CIncrease the size of the redo log buffer.
- DEnable Automatic Memory Management (AMM).
- EIncrease the size of the temporary tablespace.
How the community answered
(55 responses)- A16% (9)
- B4% (2)
- C7% (4)
- D73% (40)
Community Discussion
No community discussion yet for this question.