Oracle Temporary Tables Getting Closer to Being Temporary

Mar 28, 2013 / By Yury Velikanov

Tags: , ,

This is a very short blog post to share good news I learned last week at the great New Zealand Oracle User Group 2013 conference. During a keynote, Tom Kyte mentioned that Oracle is going to introduce a Temporary Undo.

Most of us know that for years Oracle temporary tables weren’t true temporary tables from a technical perspective, as any change would generate UNDO data and UNDO would generate corresponding REDO. Therefore, changes on temporary tables generated a REDO. Depending on the application, a REDO stream generated from temporary tables could be significant. REDO volumes have a direct impact on database recovery. Databases must apply all REDO data in case of recovery (including temporary tables REDO). This is going to change soon.

Yury
View Yury Velikanov's profile on LinkedIn

BTW: I really enjoyed the conference. This was one of the very best if not the best conferences I have attended in the region. If you have the chance to be part of it in the future, then don’t think twice. Go for it :)

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>