Oracle Temporary Tables Getting Closer to Being Temporary

Posted in: Technical Track

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 :)

Interested in working with Yury? Schedule a tech call.

About the Author

Yury is a nice person who enjoys meeting and working with people on challenging projects in the Oracle space. He started to work as an Oracle DBA 14 years ago (1997). For the past 10 years (since 2001) his main area of expertise is Oracle e-Business Suite. Yury is an OCP 7,8,9,10g and OCM 9i,10g. He is a frequent presenter at Oracle related conferences such as Hotsos, UKOUG and AUOUG. Yury is a socially active person. Apart from Social Media (Twitter, Bloging, Facebook) he is the primary organizer of Sydney Oracle Meetup group (250 people). So if you happen to be in Sydney (Australia) drop Yury a message and stop by at one of his Meetups.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *