Open POP, SPS
U2L Construction Project (Advanced)
Performance Improvement/Tuning
In the process of DB upgrade (11g > 19c) of the Welcome Savings Bank infrastructure improvement project,
Analyze the impact of changes in SQL performance and predict performance degradation due to plan changes.
By supporting rapid performance stabilization for SQL through early optimization,
Contributed to the successful execution of DB Upgrade tasks and DB stabilization.
After opening, it is provided for developer self-check of quality and performance of development SQL and to prevent failure of operational DB.
A situation where various open pop functions are gradually applied.
The solution
Selection of SQL change targets according to DB Version (19C) Upgrade and full inspection 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 in new operating DB and SQL performance optimization process and performance/history management
Operational DB inspection and periodic comprehensive diagnosis
Comprehensive performance diagnosis and quality (failure-causing factors) check for running SQL
Eclipse-based and OpenPop Web-based development SQL self-quality/performance check