Database performance issues arise in various forms, caused by various factors, in various environments; and MaxGauge provides various functions to monitor and analyze such issues. The Practical Troubleshooting deals with issues that occur more frequently in general, among various kinds of performance issues. Especially, it provides a process of analyzing performance issues caused by situations such as the batch program or batch query which have been performing normally, not performing within the batch window, and competitions such as lock.
We hope the following case studies will help you to become familiar with MaxGauge’s performance analysis methodology.
The Oracle ensures data consistency through the lock mechanism. This is very essential in terms of transaction protection. However, when multiple users are trying to change the same data, there is a high chance of generating a lock wait phenomenon. Therefore, in order to minimize the lock wait time, you must reduce the transaction process time as much as possible.