• ASH and AWR - Azure - Oracle

    The Layman’s Term Guide to AWR for Microsoft- Part I

    March 11, 2020 - By 

    As often as I use the Automatic Workload Repository(AWR) data in my day-to-day job at Microsoft, I think most can imagine how often I’m explaining its value, along with tracing to my Microsoft peeps. Its time to write a post dedicated to the Microsoft crowd who want to understand a bit more about AWR, so hopefully its helpful! What is the Automatic Workload Repository? The Automatic Workload Repository, (AWR) had been around since Oracle 10g and requires the diagnostic and tuning management pack licensing to use all of its features in Oracle’s Enterprise Edition database. Versions before 10.2.0.4 had limited…

  • ASH and AWR - EM12c Performance - EM13c - Enterprise Manager

    Displaying CPU Graphs For Different Time Ranges in Enterprise Manager

    February 18, 2016 - By 

    This question was posted in Twitter from @matvarsh30, who asked, “How can I display CPU usage over different periods of time for databases in Enterprise Manager?” Everyone loves their trusty Top Activity, but the product’s functionality is limited when it comes to custom views and this is what our user had run into. There are numerous ways to display this data, but I’m going to focus on one of my favorite features in the product that was created to replace Top Activity, ASH Analytics. Retaining AWR Data for ASH Analtyics Note: This process to display CPU graphs will work for…