Study Of Performance Analyzing And Tuning Methods Of Database Application System

The tuning for database system is vital to the normal running of the whole system, but it is a complicated work.This paper analyzes all kinds of performance problems that may occur on Database Server, application programs, OS and network during the running of Database application system. Then put forward some usual methods to settle them based on Oracle databse. Tuning for Databse Server includes the tuning for memory and I/O. In order to tune memory we describe how to improve the sharing for memory; And the tuning for I/O mainly includes decreasing the contention of I/O by reasonable distribution of physical and logical strcture, adjusting the storing of data, and the optimizing for rollback segment and redo log. The tuning of application programs mainly includes the optimizing of SQL, this paper describes how to excute SQL trace and explain plan to get the estimate for the effect of the excution of SQL, and then put forward some tips for tuning SQL. While discussing the tuning of OS and network, this paper emphasizes how to increase the resource serving for database by reducing the resource taking up by other applications, and how toimprove the performance of network by reducing the flow on network.At last,this paper introduces the general rules and methods to tune Database application system bytuning an example.