ORACLE Database Performance Tuning And Optimization In ERP System

With ORACLE database system is widely used in all walks of life applications, the database performance optimization of the system more and more important. Analysis of domestic and international strategies of optimizing database performance, combined with the existing tuning methods on pre-made version of ERP products for performance testing, performance issues for products in the diagnosis, analysis and optimization, reducing the ERP product development cost.In accordance with the principles of database performance optimization built a database environment, including: rational allocation of database parameters, distribution and rational planning disk space for the initial storage settings table. Performance testing tools measure the performance of ERP systems, compared to objective analysis system optimization problems. Study the performance bottleneck diagnostic method. Combined with vmstat, top command of the operating system performance data, the initial judge performance bottlenecks; combination statspack report, the dynamic performance view to further diagnose database performance, positioning performance bottlenecks.A set of optimization methods for ERP system. Main optimizing the database (memory parameters) and applications (SQL statements, indexes).Experimental results show that after adjustment and optimization, response time, server resources occupancy rate, etc., to achieve the desired goals, meet the requirements of release...