Blog

Plotting average read and write operation size by ASM disk for Oracle

  Throughput, throughput, throughput – for many databases, this is the performance measure of importance.  When you are working with a fixed number of IOPS but see mixed workload types, system health can be assessed through the average read and write operation size.  In an ASM environment, we can query this information by ASM disk from gv$asm_disk_stat as follows:

  While the output of this query is nice, it would be much nicer to consume visually.  Furthermore, while similar plots are available in OEM or 12c, many organizations have chosen not to implement these options.  Combining R, ggplot2, and my tutorial on connecting RJDBC to Oracle, we can summarize information like this using a low-cost query and no additional hardware or software.

 

Average Read Operation Size by ASM Disk

Average Read Operation Size by ASM Disk

Average Write Operation Size by ASM Disk

Average Write Operation Size by ASM Disk

  If you’re interested in replicating this plot, you can find the gist to plot average read and write operation size here.

  Interested in custom reporting or analysis on your databases’ data or performance?  Please don’t hesitate to reach out.

Leave a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>