Blogs > Technology > Oracle 19c ANA Upgrade Regression Test 
Oracle 19c ANA Upgrade Regression Test 
Mar 03 2023 |4 min read
Problem Statement

19c Oracle ANA upgrade migration required testing of all objects utilising  ANA from FES / Analytics . Performance, Stability and Scalability were focus areas. The objective is to move to high end database that allows dynamic workloads and improved performance & high-end availability

Scope of Work Included
  • Upgrade 19c ANA on one environment & report for any DB concerning issues for the ~1000 objects 
  • Identify long running process/failures post upgrade & report them to DB & FES team
  • Conduct deliverables call with Analytics/FES/DBA team on project progress over the period of 3 months
Key Services Offered
  • 24x5 Support structure for two dedicated environment end-to-end support 
  • Infra health check final analysis 
  • SLA/Incident/Problem Management for any Replication/DB latency/Snap runtime issues reporting 
  • Deployment planning & process capability to run on infra
  • NC  job regression run in delta4[upgraded ANA version]  vs delta2 [non upgraded ANA ] - long running /failures detailed evaluation
  • Impact analysis for ensuring data sanity 
  • Debugging, Monitoring & Data validation support for critical process
  • Alert setup with DBA team on runtime performance for Delta related Snap
  • Team created weekly plan to deliver batch of jobs for detailed analysis & following call for better approach or process improvement

Our Trending Blogs

There are no more Blogs

Sunpreet Kaur

Blogs you may like

There are no more Blogs