【作者】 陈志敏；

【导师】 刘锋；

【作者基本信息】 安徽大学 ， 计算机软件与理论， 2011， 硕士

【摘要】 数据库系统的性能是影响生产系统效率的重要因数。许多使用到数据库的系统在进入到生产阶段一段时间以后都会产生一定的性能问题,和服务器硬件、数据库的内存设置、操作系统、数据库初始参数设置都有可能有关系。因此,数据库的性能调整与优化对于整个生产系统的正常运行起着至关重要的作用。随着企业数据的不断扩展,单实例数据库已经不能满足要求,于是产生了数据库高可用性集群技术。从而,对于如何使用数据库集群技术,如何保障数据库高可用性集群技术在生产系统上面有很好的应用就成为了数据库研究的一个重要课题。本文是在基于Linux操作系统基础上,研究针对Oracle RAC系统行之有效的优化方法,能够提升系统的性能。本文首先对Linux系统的内核参数和OracleRAC技术进行了研究。和Oracle单实例数据库相比,RAC集群无论在逻辑结构还是物理结构上都有了很大的变化。通过分析RAC集群Cache Fusion这一机制,设计了以Service的质量为要求并且根据并发访问量为前提条件,对Service进行分组这一优化方法,分散了工作负载,从而使得集群中不同节点之间的数据能够同步,不会产生冗余。通过对Oracle RAC的Shared Pool、Buffer Cache、Cache Fusion的分析,研究了针对Oracle单实例数据库优化的方法在RAC中优化的可行性。在Oracle RAC系统中,对于Shared Pool以及Buffer Cache的优化在一定程度上也可以提高集群系统的性能。最后通过VMware虚拟机搭建了一个RAC集群实验平台,并设计了一个图书管理系统,进行了三组实验,对在Oracle单实例数据库以及RAC集群上使用不同的优化方法以后的性能结果作了分析比较。最后一个实验应用了本文设计的Service优化分组方案,对Oracle RAC系统进行了优化。通过实验可以知道,经过优化以后的RAC集群系统的性能要比经过优化的Oracle单实例数据库的性能要好,具有比较重要的现实意义。更多还原

【Abstract】 The performance of Database system is an important factor of production systems’efficiency. After a period of time, many production systems will have some performance issues, which are likely to have relationships with the server hardware, data block memory settings, operating system, the initial parameters of database and so on. Therefore, the optimization of database performance for the normal operation of the entire production system plays a vital role. Moreover, with the continuous expansion of enterprise data, single-instance database can no longer meet the requirements, so there is the database high-availability clustering technology. Therefore, it has become an important research topic about database how to well use the database clustering technology and how to use high-availability database clustering technology in the production system.Based on the Linux operating system, this article researches the effective optimization method, which can increase system performance. Firstly, the article studies Linux system kernel parameters and Oracle RAC technology. Compared to Oracle single-instance database, in terms of logical structure or physical structure, RAC cluster has a lot of changes. By analyzing the Cache Fusion mechanism, it has designed an optimization schema using service for the requirements of the quality of the Service and the concurrent access. This schema has distributed the work load and makes the data between different nodes synchronized and no redundancy.Secondly, by analyzing the shared pool, buffer cache, cache fusion in Oracle RAC, it researches the feasibility of tuning Oracle RAC. To some extent, optimizing the shared pool and buffer cache can also improve the performance of cluster system.Finally, it has built a RAC cluster experimental platform using VMware virtual machines. Also it has designed a library management system and has carried out three experiments in single-instance and Oracle RAC cluster database. There are different optimization methods on the platform. After that, the results are analyzed and compared. The last experiment optimizes the Oracle RAC using service tuning schema. Through these experiments we can know, after the tuning process, the performance of Oracle RAC system is better than the performance of Oracle single-instance. So it has more important practical significance.更多还原