What is the recommended action to improve performance?

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.)

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *