DBA & Infrasturcture
Wednesday, 18. October 2017., 09:00
I will start with some a high level overview of the functionality provided, and how it enhances the feature-set of Enterprise Manager. I 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. I will then build on that to provide some ideas about how to troubleshoot, and some workarounds for some of the limitations of the product.