Automating Oracle ORION I/O testing

Oracle ORION is a powerful tool for evaluating realistic OLTP and DSS/DW I/O performance.  ORION should be a part of every Oracle professional's toolkit for build QA and performance tuning.  I've previously used it on this blog to show the performance of Amazon's hi1.4lxarge SSD-backed instances and newer hs1.8xlarge instances with 117GB of RAM and 48TB of

By |2013-10-29T07:00:19-04:00October 29th, 2013|Consulting, Programming|0 Comments

AWS EC2 hs1.8xlarge Oracle ORION benchmark results

Benchmarking I/O with Oracle ORION is an important part of planning, baselining, and performance-tuning Oracle environments.  I've previously provided ORION results for the hi1.4xlarge SSD-backed instance class, and based on some recent work, I wanted to provide an update for the newer hs1.8xlarge instance class.  Below you'll find hs1.8xlarge Oracle ORION benchmark results with the following

By |2013-10-28T19:33:07-04:00October 28th, 2013|Cloud, Consulting, Infrastructure, Programming, Research|1 Comment

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

Automating Oracle Database deployment with Amazon Web Services, fabric, and boto – SEMOP Talk, Feb 12, 2013

I'll be giving a talk tonight on automated Oracle database deployment at the SouthEast Michigan Oracle Professionals (SEMOP) Meetup Group. While I'll be following up on this post later, I wanted to share the slides and Github repository for participants to follow along: Automating Oracle Database deployment with Amazon Web Services, fabric, and boto from mjbommar Github

By |2013-02-12T17:02:23-05:00February 12th, 2013|Cloud, Consulting, Programming|0 Comments

Connecting R to an Oracle database with RJDBC

In many circumstances, you might want to connect R directly to a database to store and retrieve data.  If the source database is an Oracle database, you have a number of options: ROracle RODBC RJDBC   Using ROracle should theoretically provide you with the best performing client, as this library is a wrapper around the

By |2012-11-22T11:00:36-05:00November 22nd, 2012|Consulting, Programming|8 Comments

Oracle ORION I/O benchmark results for AWS EC2 hi1.4xlarge instance type

  In a typical Oracle database implementation, you'll want to baseline or benchmark your storage.  The storage team will hand over, and you'll run a battery of tests using software like bonnie++ or ORION.  You'll make sure that the results are in-line with requirements and expectations.   What if you are implementing said database on

By |2012-10-24T00:09:41-04:00October 24th, 2012|Cloud, Consulting, Programming, Technology|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

OTM in the Cloud: Hosting Architectures, Part 2 – 1+RDS

  In our last post on cloud architectures, I covered a simple one-node Oracle Transportation Management instance on Amazon Web Services using EC2.  This OTM cloud hosting configuration is well-suited to a development environment and is a very inexpensive option for teams that have on-staff database administration skills.   For teams that do not have the

By |2012-05-31T18:36:06-04:00May 31st, 2012|Cloud, Consulting, Technology|0 Comments

Oracle Transportation Management (OTM) in the Cloud: Hosting Architectures, Part I – Single Node

  As I mentioned on Monday, I'll be starting a series of posts on Oracle Transportation Management (OTM) in the cloud.  In the first stage of these posts, I'll be covering the set of feasible architectures given the infrastructure offerings at Amazon Web Services.  And, as you might expect, we'll be starting with the simplest

By |2012-05-23T21:12:03-04:00May 23rd, 2012|Company News, Consulting, Technology|1 Comment

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