Dissertation > Excellent graduate degree dissertation topics show

Research of the Performance Tuning and Optimization of Oracle RAC Cluster System on Linux Platform

Author: ChenZhiMin
Tutor: LiuFeng
School: Anhui University
Course: Computer Software and Theory
Keywords: Oracle RAC Service Optimization of the Performance Cache Fusion
CLC: TP311.13
Type: Master's thesis
Year: 2011
Downloads: 76
Quote: 0
Read: Download Dissertation

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.

Related Dissertations

  1. Research on Effectiveness Evaluation Methods of Weapon Systems,TJ06
  2. Research on Service Registration Technology in Ad Hoc Networks,TN929.5
  3. Service Model Driven Architecture (SMDA) Oriented Modeling Techniques and Tool Implemention,TP311.52
  4. Design and Implementation of Windows Kernel-mode Cryptographic Service Interface,TP309.7
  5. The Empirical Research on Service Encounter Affecting Customer Loyalty of Female Underwear Brand,F274
  6. Study on Chinese Local Service-oriented Government Building,D625
  7. Study on Current Situation and Constructive Suggestions of Establishment of Our Service-Oriented Government,D630
  8. Research on Internetware Evolution Model of Service-Oriented Entity,TP311.5
  9. Research and Implementation on Service-Oriented Multi-Agent System Cooperation Mechanism,TP393.09
  10. The Evaluation and Research Rural about Ecological System Service Function,X171
  11. Urban Community Security Service Research in Terms of New Public Service Theory,D631.4
  12. An Exploration of the Decision-making Mechanism for a Service-oriented Government,D035
  13. Research on the Problem of Building the Service-Oriented Government of Handan City,D630
  14. National Tax System of Grass-roots Civil Servants Incentive Mechanism Research,D630
  15. The Research on Innovation of BDA’s Public Service System for Enterprises,D630
  16. Structure the Institution of Chinese Archives Rendering the Service of Government Information Publicity,G273.5
  17. Theory of China’s Carbon Emissions and Strategy Research in Service Outsourcing,X321
  18. The Research of Property Management Patterns for Rural Household Biogas in Jiangsu Province,S216.4
  19. Citizen Participation of Urban Inhabitant: Structure and Measurement,B849
  20. Survey and Analysis on Home Care Services for Elderly in Wenzhou,D669.6
  21. Lijiang City, urban and rural basic public service equalization,D67

CLC: > Industrial Technology > Automation technology,computer technology > Computing technology,computer technology > Computer software > Program design,software engineering > Programming > Database theory and systems
© 2012 www.DissertationTopic.Net  Mobile