Functions and Features of Oracle UNDO

advertisements

_____________________________________________________________________________________________________________________

Overview:

UNDO is an oracle method to rollback or undo the changes to the database. UNDO keeps track of the oracle transactions, mainly before the commit of the transaction. Block level changes are recorded ‘in time’ to provide the read consistency.

Why Oracle use the undo?

ð  For transaction rollback

ð  During the database recovery

ð  For instance recovery

ð  For Flashback features

_____________________________________________________________________________________________________________________

Live Traffic Feed

A visitor from Leioa viewed 'Create PFILE SPFILE from memory 11g New Feature' 2 mins ago

A visitor from Mumbai viewed 'How to Check Active Transaction in Oracle Database' 8 mins ago

A visitor from Mumbai viewed 'How to Check Oracle 11g 12c Database Wallet is Ope' 27 mins ago

A visitor from Fuerstenwalde viewed 'Fix ORA-12712: new character set must be a superse' 30 mins ago

A visitor from Volgograd viewed 'Implement Delay or Sleep in Oracle PL SQL Scripts ' 31 mins ago

Real-time | Get Script | More Info