Database Administration (MOSC)

MOSC Banner

How Undo statement is generated on Redo Log after the Transaction Rollback?

edited Aug 26, 2017 5:00AM in Database Administration (MOSC) 6 commentsAnswered

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center