Which three are benefits of using temp UNDO when performing DML on global temporary tables?

Temp UNDO is a feature that stores undo data for global temporary tables in the temporary tablespace instead of the permanent UNDO tablespace. This provides three key benefits: (1) It allows DML operations on global temporary tables even when the database is in read-only mode, since temporary tablespaces remain writable; (2) It reduces UNDO tablespace usage by redirecting temporary table undo to temp tablespaces; (3) It significantly reduces redo generation because changes to temporary undo segments generate minimal redo compared to permanent undo segments.

C. Temp UNDO affects temporary and UNDO tablespaces, not SYSTEM tablespace I/O operations.
E. SYSAUX tablespace is not involved in temp UNDO operations for global temporary tables.

1. Oracle Database 23ai Concepts Guide, Chapter 12 "Temporary Segments", Section "Temporary Undo", Doc ID: E96224-01

2. Oracle Database 23ai Administrator's Guide, Chapter 16 "Managing Undo", Section "Using Temporary Undo", Doc ID: E96196-01

3. Oracle Database 23ai New Features Guide, Chapter 3 "Performance and Scalability", Section "Temp Undo Enhancements", Doc ID: F47869-01

4. Oracle Support Note 2449128.1 "Temporary Undo for Global Temporary Tables in Oracle Database"

5. Oracle Database 23ai SQL Tuning Guide, Chapter 14 "Managing Database Performance", Section "Reducing Redo with Temp Undo", Doc ID: E96192-01