Redefining Simplicity & Agility For Oracle DBAs

Today’s Oracle DBAs spend the majority of their time each week diagnosing and tuning performance, maintaining availability, and creating and maintaining copies of databases, while trying to drive greater database consolidation to improve simplicity (source: IOUG 2014 Survey). How can storage simplify these tasks for Oracle DBAs while meeting service level objectives to the business? The answer lies in redefining Oracle storage platforms.

To put XtremIO to the test, EMC performed both internal testing as well as external third-party audited tests with Principled Technologies. Let’s have a look at the results.

Predictable Breakthrough Performance

XtremIO all-flash-arrays (AFAs) maximize performance as everything is consistently fast, no matter what the mix of OLTP and OLAP and no matter how many instances are running. This means a DBA doesn’t have to waste time ever again architecting the databases for the storage or tuning the storage for the databases. DBAs simply request the new instances and go. A six X-Brick XtremIO cluster scales linearly to deliver over 1M fully random OLTP IOPS with <1 millisecond latency, regardless of the database size or access pattern.  But isn’t every AFA fast? What about other AFAs?

Oracle XtremeIO 2

* The results are based on XtremIO software version 2.4.  Version 3.0 was released today and is even faster.

As the above test results indicate, the answer is “No.” XtremIO relies upon the flash controller in each SSD to handle the low-level flash management process called garbage collection. This, along with other XtremIO architectural innovations, free XtremIO arrays from processes like log structuring and system-level garbage collection that make performance lower, inconsistent, and unpredictable.  EMC has tested and documented a detailed solution showing how XtremIO delivers more consistent performance with ~80% more database I/O and ~3X to 30X reduction in latency to maximize SLAs. 

Greater Consolidation & Agility For Oracle DBAs

According to a 2014 IOUG survey the majority of customers have up to 100 different Oracle databases to manage, each of which requires copies for test, development, reporting or analytics. DBAs are wary of consolidating them on a common storage platform with the sacred production instance, so such storage sprawl has persisted even in virtualized database environments.

A way to start tackling this challenge is to look at how to copy and deliver the same performance profile while meeting the combined SLAs of all consolidated instances. Oracle database copies on XtremIO (whether VM clones or writable snapshots) are fingerprinted in memory, deduplicated, and compressed inline all the time allowing more copies and capacity, and most importantly, all flash all the time.  XtremIO’s scale-out architecture ensures there is the performance to handle this level of workload consolidation.

But what about virtualizing? XtremIO combined with VMware integration (VAAI) uses the inline deduplication and in-memory metadata of XtremIO to allow VM clone processes to be offloaded from the Oracle database host and performed entirely in memory, at lightning speed, on the XtremIO array.

Principled Technologies Testing

EMC XtremIO & VMware put this to the test at the labs of Principled Technologies (PT). PT configured a core production Oracle 12c database and proceeded to clone the database while workloads ran against the production system. PT test results documented here showed DBAs can now provision:

–         One multi-terabyte VM in minutes

–         17 different sized VMs in seconds

–         50 x 50 GB VMs – each new VM provisioned in seconds

PT’s testing indicates that DBAs can confidently copy and deploy multiple mixed workload databases on the same array as production while maintaining space efficiency and quality-of-service.

Please visit the EMC Community for Oracle DBAs and for solutions, blogs, and best practices for databases and other application environments.

About the Author: Dell Technologies