摘要
Oracle行级触发器应用中常遇到变异表错误,急需一个高性能的解决方案。概述Oracle DML触发器的特点,给出变异表错误出现的场景,分析出现错误的原因,提出分别基于包变量、临时表或复合触发器的3种解决方案,大规模数据测试表明:基于复合触发器的解决方案性能最好。
A mutating table error is often encountered in the Oracle row trigger application, so a high performance solution to the problem is needed. The characteristic of Oracle DML trigger was summarized, the scene of the mutating table error was given, and the reason for the error was analyzed. Three solutions based on the package variable, temporary table or compound trigger were proposed, a large-scale data testing indicates that the performance of the solution based on the compound DML trigger is best.
出处
《湖北汽车工业学院学报》
2013年第4期49-52,共4页
Journal of Hubei University Of Automotive Technology
关键词
触发器
变异表
包变量
临时表
自治事务
trigger
mutating table
package variable
temporary table
autonomous transaction