How Undo statement is generated on Redo Log after the Transaction Rollback?
Hi Friends,
I am just inserting 10 million records and the transacations are being recorded in redo log buffer and being flushed to redo log file and log switch happens
and archived logs are cretead (assume 10 arc logs are cretaed)
Now at the end of Transaction i am not commiting it and rolling back the transaction.
From Oracle Block perspective perspective:
the old imageblock from undo is used and written to datafile
From Redo Log perspective:
Now the Redo logs (10 Archived Logs+ current Redo Log) has the uncommited transaction so the redo log will add the rollback statement (delete against insert) in the Redo Log?