SPS
Building the next generation information system
U2L DB Upgrade Performance Stabilization and Improvement
Openpop is a DB upgrade (11g > 19c) in accordance with the strategy of Jeonbuk Bank U2L project (operator > LG CNS).
In the process, it automatically analyzes the impact of changes in SQL performance, and supports rapid performance stabilization of SQL through early optimization of SQL expected to experience performance degradation due to plan changes, thereby successfully performing DB Upgrade tasks and stabilizing DB.
The solution
Selecting SQL change targets according to DB Version (19C) Upgrade
Full check of SQL execution errors in 19C environment
Support for SQL performance comparison verification and performance optimization in the current operating DB (11g) and new operating DB (19c) environments
Early performance verification of APP/SQL on new operating DB
SQL Performance Optimization Process and Performance/History Management