5.1 Oracle Database 2 Day + Performance Tuning Guide (E83714)

In Section 9.3 “Using the AWR Compare Periods Reports” in Chapter 9 “Resolving Performance Degradation Over Time”, the following two new subsections have been added to the Automatic Workload Repository (AWR) Compare Periods report in 18.1:

  • Top Process Types by Wait Class

    This section shows top process types ordered by wait class.

  • Top Process Types by CPU Used

    This section shows top process types ordered by CPU time.