0

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?

Saman
  • 333
  • 3
  • 9

1 Answers1

1

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

Littlefoot
  • 131,892
  • 15
  • 35
  • 57