Category: Case Studies

United Physicians Achieves Performance and Reliability

 

United Physicians Achieves Performance and Reliability

with Oracle Database Appliance

IT Transformation with ODA

Background

United Physicians (UP), is a network of physicians that contracts with health plans, whose members have medical staff privileges at hospitals and healthcare systems. While the company’s network has grown, so has their IT footprint. Initially, UP deployed their databases and applications with all SSDs in a virtualized Oracle Database Appliance (ODA) X6-2. Oracle Platinum Partner, Viscosity North America (Viscosity), was brought in, to provide a solution for their ODA X6 patching and guidance in a go-live strategy.

Solution and Proposal

Viscosity reviewed AWR reports and I/O workloads to determine their IOPs, throughput and latency metrics to determine their future hardware roadmap. Based on their I/O requirements, Viscosity was able to assure UP that the new appliance would not only provide performance, but also have enough capacity for future growth. Viscosity also educated UP to consider information life cycle management with tiered storage on the ODA. After Viscosity spent time providing resources that could act as a trusted advisor, and walk through UP’s roadmap and its correlation to Oracle, UP became open to discussing the purchase of an ODA X7-2.

Agile Virtualization with ODA

Viscosity worked with UP through the process to have them purchase an ODA with SSD and HDD, giving them both the performance and capacity required for their production environment. After the ODA X7-2 was initiated, Viscosity experts were onsite
to standup the ODA.

Deep Virtualization

UP deployed four virtual machines for their application stack on the ODA X7-2, allowing them to fully utilize the ODA as their go-to virtual infrastructure. However, this proved to be a more difficult task than initially believed, as the latest patch was not as stable as expected. Viscosity honored their commitment for success and provided services, free of charge, to ensure that UP was patched to a stable update.

Memory Expansion

After production go-live, Viscosity was asked to patch the ODA X6-2, resell memory upgrades to the maximum configuration, and collaborate with UP to effectively utilize their Dev and Test environment as the ODA X7-2 will be for production. Viscosity will continue to be their trusted advisor, as they provide end to end monitoring with Oracle Cloud Control 13c.

Healthcare Analytics

Health Plan Provider Simplifies with Oracle Database Appliance

 

Background

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.