Friday, April 19 • 3:45pm - 4:30pm
The ins and outs of Total Recall (P3)

Sign up or log in to save this to your schedule and see who's attending!

Learn how you can use Oracle Total Recall to easily access historical data in your applications. This presentation starts with a basic overview of Total Recall and Flashback functionalities and how developers and ISVs can use it in their applications including an introduction to the basic syntax of flashback queries. The second part of the presentation focuses on the inner workings of flashback archives, how Oracle makes use of partitioning and compression to achieve a great level of performance for these types of queries. Lastly, I will talk about best practices when dealing with flashback enabled tables like setting up testcases, exporting historical data to development databases, performing DML on those tables and other issues we have come across in the last two years.

avatar for Björn Rost

Björn Rost

portrix systems GmbH
Björn is the co-founder and CEO of a full service provider focused on Oracle Technology from Servers, Storage and Solaris to Real Application Cluster databases and Desktop Virtualization. He is passionate about sharing knowledge and has enjoyed speaking at several conferences and... Read More →

Friday April 19, 2013 3:45pm - 4:30pm
4. Congress Color Magic