News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Using the AWR History Tables to compare performance – Part 2

  • Posted by Gavin Soorma
  • On April 1, 2010
  • 0 Comments
In the Part 1 of this post, we saw how we can use the AWR history tables to compare the top wait events between two different time periods. We will now use the history tables to track and identify problem SQL statements. Suppose we have been informed that there was a I/O performance issue early […]
Read More
 

Using the AWR History Tables to compare performance – Part 1

  • Posted by Gavin Soorma
  • On April 1, 2010
  • 1 Comments
Using the DBA_HIST AWR history tables, we can compare the top wait events between different days or different time periods. Let us assume that we find that batch jobs which are executed at night particularly between 1 and 2 AM are experiencing performance issues. In this case we are comparing performance of a particular database […]
Read More
 

Exporting and Importing AWR snapshot data

  • Posted by Gavin Soorma
  • On July 25, 2009
  • 0 Comments
The AWR tables contains a wealth of important performance data which can be very useful in performance tuning trend analysis and also when comparing performance between two seperate periods of time. AWR data is stored in the WRH$ and DBA_HIST tables in the SYSAUX tablespace. There could be performance implications if these tables were to […]
Read More