Worked in Database technology for fixed the issues faced in daily activities in Oracle, Sql Server, MySQL etc.

Temporary undo in Oracle 12c

Temporary undo in Oracle 12c

In prior Oracle, the temporary table generated undo data to be stored in undo tablespace.
With this new feature in Oracle 12c R1 , the temporary table record stored in Temporary tablespace instead of undo teblespace.

Benefit:
1. Reduction in use of undo tablespace.
2. Less redo data generation.

Problems in pre Oracle:
1. Undo generated with global temporary tables increase the size which lead to more space needed to meet the undo retention period.
2. Temporary tables has transient data, which is not needed, so generating redo for temporary data add additional load on the system.