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

June 12, 2013
By

(This article was first published on Bommarito Consulting » r, and kindly contributed to R-bloggers)

  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 his blog: Bommarito Consulting » r.

R-bloggers.com offers daily e-mail updates about R news and tutorials on topics such as: visualization (ggplot2, Boxplots, maps, animation), programming (RStudio, Sweave, LaTeX, SQL, Eclipse, git, hadoop, Web Scraping) statistics (regression, PCA, time series, trading) and more...



If you got this far, why not subscribe for updates from the site? Choose your flavor: e-mail, twitter, RSS, or facebook...

Comments are closed.