In regard to undo generation, private temporary tables behave similar to global temporary tables. We can see that by running Read More
As part of processing transactions, Oracle captures how the data is modified (redo) and writes that information to the log Read More
