P50 The Power of the AWR Warehouse by Kellyn Pot'Vin-Gorman

Date & Time

Mar 13th at 3:00 PM until 3:45 PM

Track

Core Tech 

Location

Rating ( votes)

The Enterprise Manager 12c Release 4 is accompanied with the new AWR Warehouse feature, which allows you to automatically extract detailed performance data from your database targets and consolidate the data into a single location within the AWR Warehouse repository. The main source of data stored in the AWR Warehouse is derived from the Automatic Workload Repository (AWR), via AWR snapshots, letting you retain long-term history of AWR data from chosen EM12c database targets, enabling long-term analysis of AWR data across databases without impacting the source.

This session will cover the power behind this incredible new feature, a full review of the architecture, ETL process and then onto what everyone who's worked with AWR data really wants to know- What is the impact to the existing suite of AWR queries and how much can it really provide the business and the DBA when searching for answers.