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

By |2013-06-12T10:01:22-04:00June 12th, 2013|Consulting, Programming|0 Comments

Plotting Oracle RMAN backup durations with R

  How long does your Oracle RMAN backup take to complete?  How does this vary over time?  Are there patterns by week, week of month, or day of week?   The gist below can help you evaluate questions like these.  If you're interested in using R with Oracle more generally, check out this previous post

By |2013-06-03T20:44:00-04:00June 3rd, 2013|Consulting|0 Comments

Debugging parameter mismatch across RAC database instances with R, dba_hist, and gv$parameter

Did you find this post useful?  Does your organization need Oracle services?  We can help.   Much of this morning went into investigating strange ADDM reports on a two-node Oracle RAC database.  For some reason, there were statistically improbable differences between impact percentages that have persisted over a month; in this case, instance 2 would

By |2012-10-09T11:48:26-04:00October 9th, 2012|Consulting, Programming, Technology|0 Comments

Top Sliding Bar

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

Recent Tweets

Newsletter

Sign-up to get the latest news and update information. Don’t worry, we won’t send spam!

Go to Top