Oracle变异表错误解决方案选择  

Choice of Solutions to Oracle Mutating Table Error

作　　者：彭彬[1] 齐心[1] 

机构地区：[1]湖北汽车工业学院电气与信息工程学院,湖北十堰442002

出　　处：《湖北汽车工业学院学报》2013年第4期49-52,共4页Journal of Hubei University Of Automotive Technology

摘　　要：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.

关 键 词：触发器 变异表 包变量 临时表 自治事务 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]