Plotting average read and write operation size by ASM disk for Oracle
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 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.
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.