ORACLE数据库的并发控制与效率分析

ORACLE Database Parallel Control and Efficiency Analysis

介绍了ＯＲＡＣＬＥ数据库环境下的各种并发控制锁及遵守的子树式协议，分析了ＯＲＡＣＬＥ数据库并发控制中隐含的问题，提出了避免“死机”的方法，并在太极机多用户ＯＲＡＣＬＥ数据库上实现了并发控制下ＯＲＡＣＬＥ数据库效率检测分析，得出了ＯＲＡＣＬＥ数据库在此环境下效率峰值是５个用户的结论。同时指出，在８～１４个用户时，随用户数的增加效率将呈阶梯性下降。

Tnis paper describes the basic parallel control scheme of an oracle relation database SyStem,both in various locks and in sub-tree agreements. By analysing the probferns occured in parallel control sharing data,we have provided an approach to avoid deadlock.In a final Part,we have present6d an efficiency test methods,and POinted out the resultS of our research. Efficiency increased when number of user increased from one to five,and decreased when 'number of user increased from five to fourteen. Especially, we have proved the efficiency decreased very fast when the number in'Creased from eight to fourteen.