Research Of The Performance Tuning And Optimization Of Oracle RAC Cluster System On Linux Platform

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.