Health Plan Provider Case Study
Learn How This Health Plan Provider Teamed Up with Viscosity to Fully Utilize Their ODA X5-2
BACKGROUND
A leading Health Plan Provider, founded in 1997, has seen continuous growth in Michigan, Iowa, Illinois, Ohio, Indiana, and Kentucky. The company provides government-based health plans, with more than 700,000 customers. They sought out an Oracle partner, with expertise in the Oracle Database Appliance, as well as Oracle Data Warehouse.
Previously the customer had purchased an Oracle Database Appliance (ODA) X5-2, and had struggled with utilizing it at its full potential for their company. They brought in Oracle Platinum Partner, Viscosity North America (Viscosity), in hopes to provide an assessment and patching for their ODA X5-2 issues, and for guidance in a future roadmap with ODA strategy.
SOLUTION
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.
IMPLEMENTATION
In parallel, with the comprehensive review of the customer’s environment, Viscosity upgraded and patched their ODA X5-2 DEV and PROD environments and databases to the newest releases. The virtualization layer provided some challenges with the ODA patching processes. However, Viscosity resolved the 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.
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 was 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 the company’s trusted advisor. With their thought leadership, Viscosity recommended that for the customer’s next upgrade be the SSD based ODA X7-HA.
