Display IOPS/MBPS in Graph
 Concept

AWR data keep track of IOPS and MBPS which are important metrics of IO statistics. We can graph them for capacity planning purpose.

 Case Study Summary

The following example describes how to retrieve IOPS and MBPS, and then display data in graph using MS Excel.

The list of cases include:

 Case 1: Display IOPS and MBPS for database over 7 days

First, we retrieve AWR data about IOPS and MBPS for database.

Secondly, we copy/paste these columns to MS Excel spreedsheet, sum up there and and create line graph.

 Case 2: Display IOPS for tablespace over 24 hours

First, we retrieve AWR data about IOPS for multiple tablespace.

Secondly, we copy/paste these columns to MS Excel spreedsheet, and and create line graph. To complare IOPS for different tablespaces can help us understand how much workload each application causes on database.

Copyright 2011 Actrace. All Rights Reserved.
Home | Product | Case Study | Support | Download | Contact Us