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

ORACLE Database Parallel Control and Efficiency Analysis

  • 摘要: 介绍了ORACLE数据库环境下的各种并发控制锁及遵守的子树式协议,分析了ORACLE数据库并发控制中隐含的问题,提出了避免"死机"的方法,并在太极机多用户ORACLE数据库上实现了并发控制下ORACLE数据库效率检测分析,得出了ORACLE数据库在此环境下效率峰值是5个用户的结论。同时指出,在8~14个用户时,随用户数的增加效率将呈阶梯性下降。

     

    Abstract: This 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 presented 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 increased from eight to fourteen.

     

/

返回文章
返回