Lift and Shift to Oracle Database Cloud at Anthem Inc.
Explore how Anthem Inc. successfully migrated to Oracle Database Cloud, addressing concerns with rapid growth and leveraging Oracle Infrastructure for enhanced performance monitoring. Learn about their journey, challenges faced, and solutions implemented to ensure a smooth transition to the cloud.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Lift and Shift with Confidence to Oracle Database Cloud @ Anthem Inc. Naushad Bhamani Sr. Database Admin Advisor, DMA Tel: (404) 309-8459 Email: naushad.bhamani@anthem.com
Introduction to Anthem Anthem is one of the nation s leading health benefits companies 2
Oracle Infrastructure at Anthem@ Until early 2014 Anthem was a major AIX shop with over 800+ databases hosting mix application (OLTP, DSS, Data warehouse). In 2014 we purchased our first Exadata X4s that consisted of two full and two half racks (6 clusters with total 20 compute nodes). In 2018 75% of our environment has moved to Exadata hardware which has grown to 28 Clusters hosting 800+ databases The demand for Exadata was growing fast and we needed something to monitor the capacity, control the usage and at the same time maximize the return on investments. Monitoring tools we used was OEM and home grown scripts gathering data and storing it in a database. 3
Concerns with the Fast Pace Growth Our goal was to address the need for a high-level, real-time capacity picture. What is the CPU used each node V/s cluster What is the memory/huge pages used, each node V/s cluster What is the IO/flash cache usage What is our storage growth Additional items to address If there are spikes in any of the above than what is the cause? Are we hitting the ceiling? Will there be a problem if one node crashes? Can we safely relocate databases to other cluster? OEM would not give us what we wanted to see! We decided to gather data in a database to create our own reports Excel was too slow in plotting charts Even Tableau was slow and the data was a day old 4
ITA Oracle Management Cloud Solutions High level Performance/Health of all clusters from the Dashboard 5
ITA Oracle Management Cloud Solutions Growth Trend of ALL Cluster using Exadata Analytics 6
ITA Oracle Management Cloud Solutions Growth Trend of a particular Cluster 7
ITA Oracle Management Cloud Solutions Growth Trend of a Particular Cluster 8
ITA Oracle Management Cloud Solutions Growth Trend of a particular Cluster (detail ) 9
ITA Oracle Management Cloud Solutions Growth Trend of a particular Cluster (detail ) 10
ITA Oracle Management Cloud Solutions SQL Analytics 11
ITA Oracle Management Cloud Solutions SQL Analytics deeper 12
Benefits Best Practices Analyze resource usage across application tiers Maximize return on your expensive investment Create and Customize your own dashboards Growth pattern allows to plan in advance for purchasing additional hardware Helps to isolate problems of a single component It helps focus on tuning work on biggest potential payoffs. One stop shop even for monitoring and tuning Log Analytics Customize right resource, for e.g. CPU/Cluster/storage/infiniband etc. Create custom dash boards Monitor on weekly basis to the least 13
Useful Links https://docs.oracle.com/en/cloud/paas/management-cloud/it-analytics.html https://cloudcustomerconnect.oracle.com/files/32e7361eed/OMC_For_EXADATA_whitepap er_v28.pdf https://apexapps.oracle.com/pls/apex/f?p=44785:24:107038340450385::NO:24:P24_CONTE NT_ID,P24_PREV_PAGE:22419,1 https://docs.oracle.com/en/cloud/paas/management-cloud/product-tour-la/index.html 14
