Health Plan Provider Simplifies with Oracle Database Appliance

Project Overview

Headquarters: Michigan

Industry: Healthcare


  • Oracle ODA
  • Data Warehouse
  • Virtualization
  • ODI
  • OBI

Healthcare Analytics



A leading Health Plan Provider, founded in 1997, has since seen continuous growth in Michigan, Iowa, Illinois, Ohio, Indiana, and Kentucky. With more than 700,000 customers, the customer provides government-based health plans, and as growth continues, they sought an Oracle partner, with expertise in the Oracle Database Appliance as well as Oracle Data Warehouse.

Previously, the customer had purchased an X5 Oracle Database Appliance, and had struggled with utilizing it at full potential for their company. Oracle Platinum Partner, Viscosity North America (Viscosity), was brought in, in hopes to provide an assessment and patching for their ODA X5 issues and for guidance in a future roadmap with ODA strategy.

Solution and Proposal

Viscosity experts performed an assessment of the customer’s Data Warehouse database, performed discovery on the servers and database, as well as assessed the current hardware configuration. Throughout this process Viscosity executed a comprehensive health check, gathered the key metrics and reviewed database parameters to maximize performance on the ODA.

Agile Virtualization

In parallel, with the comprehensive review of the customer’s environment, Viscosity upgraded and patched their ODA X5 DEV and PROD environments and databases to the newest releases.

The virtualization layer provided some challenges with the ODA patching processes, but Viscosity resolved issues quickly by persistently following up with Oracle support and communicating effectively with the customer. Within two weeks of the engagement kickoff, Viscosity was able to complete the upgrade of DEV and PROD.

Hardware Recommendation

As part of the assessment, Viscosity recommended their roadmap for their next hardware refresh. By reviewing AWR reports and I/O workloads to determine their IOPs, throughput, and latency metrics, Viscosity is able to provide the right-sized recommendations to their future hardware roadmap.

After successfully upgrading their development and production ODAs within two weeks, Viscosity became their trusted advisor. With the thought leadership, Viscosity will recommend to the customer to upgrade to the SSD based ODA X7 HA.

Other Viscosity North America Specialized Services Include:

  • License and Asset Management Services
  • Real Application Clusters (RAC)
  • Data Guard / ASM
  • GoldenGate / Shareplex
  • Database Performance Tuning
  • Database Managed Services
  • Database Upgrades with Zero Downtime and Zero Risk
  • E-Business Suite Administration and Upgrades
  • Exadata
  • Exadata Managed Services
  • Data Warehousing
  • Big Data (Cloudera with Hadoop and NoSQL)
  • Consolidation



Why Choose Us

Viscosity North America was founded by industry and authored experts with backgrounds in Oracle, Hadoop, VMware, and Informatica. As an Oracle Platinum Partner, Viscosity is known as the “Trusted Advisors”, specializing in the delivery of full stack solutions and resolving complex data challenges. Their vast experience in verticals such as Oil & Gas, Healthcare, Finance, and Retail, provides their customers with insight into what is driving IT complexity. Viscosity offers solution services in the areas of Cloud implementation and Integration, Big Data, Analytics, Mobility, Engineered systems, Middleware, and Enterprise apps, as well as solutions in full stack health checks, license assessments, and custom application development. Contact us to learn more about how you can maintain and maximize your investments.

Viscosity was formed by former Oracle employees each of which worked in various capacities within Oracle Corporation. These capacities include Oracle Database, RAC Development, Oracle Consulting and Oracle Technical Architects, Design and Performance Tuning experts. Viscosity’s Oracle Center of Expertise has developed best practices and tight partner relationships to implement world-class solutions. Our vast experience and intellectual property give customers insight into what is driving IT complexity. We can deliver a set of practical executable plans for simplifying IT infrastructure, helping reduce operating costs while freeing up resources for new business initiatives.