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

[This article was first published on Bommarito Consulting » r, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

  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.

To leave a comment for the author, please follow the link and comment on their blog: Bommarito Consulting » r.

R-bloggers.com offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)