Oracle Temporary Tables Getting Closer to Being Temporary
Mar 28, 2013 / By Yury Velikanov
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.
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