Tasha Stone

CIO Blog: Hitachi’s Database Infrastructure Evaluation Tool for Oracle in Action

Discussion created by Tasha Stone Employee on Oct 28, 2015

Branded blog post from CIO.com discusses:

Hitachi’s Database Infrastructure Evaluation Tool for Oracle in Action




By Paul Desmond


For more than 20 years, the world’s largest organizations have trusted Hitachi Data Systems (HDS) to support their most critical and demanding applications – most of which sit on top of an Oracle database. In fact, more than 80% of the global Fortune 100 uses HDS solutions to support their Oracle databases and applications. 


As I wrote about in my last post, HDS knows quite a bit about what it takes to run mission-critical Oracle environments and has packaged 20-plus years of knowledge – more than 250 best practices – into the HDS Database Infrastructure Evaluation Tool (DIET). DIET analyzes the Automatic Workload Repository (AWR) reports that Oracle databases and applications generate for diagnostic purposes and creates a detailed analysis and recommendations for improving database performance and increasing storage efficiency. 


DIET has been used by more than 800 companies representing more than 15,000 Oracle databases over the past seven years, adding new features and more data-gathering and reporting capabilities along the way. The newest version of DIET adds the ability to analyze AWR Global RAC reports for an entire Oracle RAC cluster concurrently, in addition to analyzing individual nodes as DIET always has done. 


Here are two examples of how DIET has helped real customers, courtesy of Tom Stutesman, Director, Global Oracle Solutions Lead for HDS.

Utility Company Improves Database Performance And Utilization


A large electric utility was running a massive Oracle application on AIX-based HDS hardware. The setup was an 8-node Oracle Real Application Cluster (RAC) with 64 cores per node. 


After running DIET, it became clear that seven of the nodes were essentially running idle and the other at only 30% utilization. The company’s threshold was no more than 70% utilization at peak periods, so it was far below that target. 


HDS engineers suggested consolidating the database to a fewer number of nodes which would increase utilization across the smaller cluster, with the added benefit of significantly reducing the total cost to run the database. In this case, the utility agreed it didn’t need all the nodes but did not want to consolidate. It did, however, go along with some DIET recommendations on how to configure the application to take better advantage of all the nodes and the underlying infrastructure. 

Solid State Drives Save the Day for Financial Services Provider


A global online financial services provider was looking to improve the performance of an online credit check application so it would finish in the time it takes a potential customer to move from one Web page to the next – in other words, milliseconds. 


After running DIET, it became clear that if the company placed certain Oracle table spaces on solid state drives, the application performance would improve enough to meet their objectives. The company tested the proposed changes and found they performed as expected. Problem solved. 


Check out DIET online; there’s a free version you can try for yourself at no charge – HDS will even email you a summary report of your actual Oracle database if you choose. 

Click here to learn how the Hitachi Unified Compute Platform (UCP) portfolio can create a more agile and flexible data center to help IT enable faster time to production, automate operations, and provide real-time business insights.

About this Blog: Hitachi Data Systems builds information management and Social Innovation solutions for enterprises. Hitachi's IT infrastructure, analytics, content and cloud solutions and services enable enterprises to leverage their data assets to meet strategic business goals. The Hitachi Unified Compute Platform portfolio of converged infrastructure products helps enterprises manage increasingly complex and critical data center operations in a way that enhances flexibility, agility, efficiency, productivity and scalability. Learn more about Hitachi Unified Compute Platform here.