You are administering a database that supports an OLTP workload. An application regularly
creates global temporary tables and a large number of transactions are performed on them.
You notice that performance is degraded because of excessive generation of undo due to a
large number of transactions on the global temporary tables. What is the recommended
action to improve performance?(Choose the best answer.)
A.
Increase the size of the undo tablespace and enable undo retention guarantee.
B.
Increase the size of the database buffer cache.
C.
Enable temporary undo.
D.
Increase the size of the temporary tablespace or make it autoextensible.
E.
Enable Automatic Segment Space Management (ASSM) for the undo tablespace.
Explanation:
https://docs.oracle.com/cd/B13789_01/server.101/b10739/undo.htm
C right
Enable temporary undo (new feature in Oracle 12c)
C
C