SPS
Nextro Advanced Business Development for Next Generation System
U2L DB Upgrade Performance Stabilization and Improvement
Openpop is a process of DB upgrade (11g > 19c) according to the U2L strategy of the next-generation project of Suhyup Bank.
Automatically analyzes the impact of changes in SQL performance and predicts performance degradation due to plan changes for SQL.
By supporting rapid performance stabilization for SQL through early optimization,
Contributes to successful execution of DB Upgrade tasks and DB stabilization.
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