AWR Warehouse: the Good, the Bad and the Ugly

Patrick Jolliffe
engPatrick Jolliffe
Li & Fung Trading Ltd



In the presentation we will start with some a high level overview of the functionality provided and how it enhances the feature-set of Enterprise Manager. We will discuss the licensing advantages of offloading historical AWR data and processing into a separate database instance.

Then we will review how the ETL process is actually implemented, particularly the tables which store metadata for the extract and load portions. Build on that we will provide some ideas about how to troubleshoot when things don't work as expected, and how to workaround some of the limitations of the product.