Research On Performance Tuning And Optimization Of Oracle

The performance of database systems eventually determines their availability and Survivability. Most of them will bring about some performance problems more or less after running for a period of time, which mainly involve database hardware, database server, database memory, applications, operating systems and database parameters, etc. Therefore, performance tuning and optimization of database systems, which concern multiple aspects, are very vital to the normal running of the whole system. We can improve the stability and availability of database, guarantee its high running efficiency, solve system bottleneck, reduce system overhead, obtain considerable applicability and in the meanwhile, provide some guidelines for theoretical research through a unified plan and systematical analysis to make appropriate adjustment.Based on the above-mentioned idea, by virtue of the practice of developing order query subsystem of a typical goods management information system and the experience of using Oracle 9i, the paper principally pays attention to the research on the performance tuning and optimization problems of SQL statements, memory allocation of Oracle and disc I/O, etc., and makes a deep analysis and discuss. It suggests in general some performance tuning strategies and optimization approaches of Oracle application systems to drive the development of Oracle performance management and optimization technology. Moreover, some problems about access efficiency of database under the Hibernate-based and JDBC-based environment are also well documented.Firstly, the paper introduces the corresponding research background of performance tuning of database, significance of selected topic and framework of performance tuning and optimization of database including their concepts, performance evaluation index and primary aspects of optimization.Secondly, it elaborates on some optimization technologies such as optimization of SQL query statement, memory allocation and tuning of Oracle, creation of index, arrangement of Oracle table space, disc division of Oracle and cluster storage. It also compares these optimization technologies and summarizes some pragmatic optimization approaches and tips for performance improvement of system.Again, based on order query subsystem of a typical goods management information system, the paper adopts corresponding performance optimization technologies to optimize concrete instances. Through a large amount of experiments, it compares and analyzes performance evaluation index before and after using every...