ORACLE数据库应用中死锁的分析及改进

Analysis and Improvement of Deadlock in ORACLE Database Application

介绍了初轧三电改造后过程计算机ORACLE数据库应用系统试运行的开始一段时间中出现的死锁现象,基于出现规律,把初轧烧钢和调度两个应用系统的数据库程序设计实现和ORACLE的内部机制相结合,试图找出死锁出现的内在原因,从而得到解决死锁的方法,即对与死锁现象有关联的应用系统进行优化设计并重新实现。

The deadlock phenomenon that appears at the beginning of trial operation of the ORACLE database application system for the blooming process is introduced. On the basis of the deadlock appearance regular pattern, the database design for the two application systems (ingot heating and scheduling) has been combined with the internal mechanism of the ORACLE database, the internal reason why the deadlock would appear has been studied thoroughly, and the way of solving the deadlock has been found out. It means that all the application systems concerning the deadlock phenomenon have been optimized.