CODEWITHSUNDEEP
oracle-databaseoracle12cundotablespaceflashback
Saman
Saman

Reputation: 393

Oracle Undo tablespace after commit and record stored after undo_retention is crossed?

When I commit a transaction in oracle, it looks like my undo segment is released. Where does my old values go after commit?

What happens to undo tablespace after we commit a transaction?

And when we flashback the table, it looks like we can still recover records even after the undo_retention is crossed, Where was the record stored during this interval?

Upvotes: 0

Views: 988

Answers (1)

Littlefoot
Littlefoot

Reputation: 142788

This is described in Documentation, Database administrator's guide, Managing Undo; link is to 11gR2, find your version if necessary.

Upvotes: 1

Related Questions