In this multipart series, learn how important new features such as Database Replay, Flashback Data Archive, Edition-based Redefinition, and SecureFiles work via simple, actionable how-to's and sample code. (Updated for Release 2!)
Many new change assurance (or "Real Application Testing," as Oracle calls it) features in Oracle Database 11g bring that dream closer to reality. The Database Replay tool, for example, allows you to capture production database workload and replay it in a test (or even the same) database to assess the impact of change. Or consider SQL Performance Analyzer, which predicts the performance impact of changes to SQL before they are made. (In my opinion, this Real Application Testing functionality alone justifies the upgrade.) After this process, Edition-based Redefinition (introduced in Release 2) enables patching and updates of data objects while the application remains online.
Overall, Oracle Database 11g makes database infrastructure far more efficient, resilient, and manageable. For example, very compelling new features in the realm of partitioning ease the design and management of partitioned tables immensely.
In this series (as in the previous series focusing on Oracle Database 10g), you will learn how these new features work via simple, actionable how-to's and sample code.
Enjoy the series, and the release!