SPS
ICT-Rebuild Construction (U2L-Cloud)
ICT-Rebuild Construction (U2L-Cloud)
OpenPOP is being utilized to automatically analyze the impact of SQL performance changes during the DB upgrade (11g > 19c) according to the strategy of the Hana Bank U2L project (executor > LG CNS), and to quickly stabilize SQL performance 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