| Since Oracle Database is widely used, the way to monitoring database real time running statistics and performance analyze is becoming to a tough task during the daily maintenance work. Also, these kinds of database management software base on graph are complex in use, high price and seldom appeared in market. Thus, Database Administrator(DBA) use command line tools to collect the system information for the most system maintenance cases, especially for those systems running on Linux/Unix Servers. Moreover, due to lack of performance tuning experience, most of DBAs are not compatible for database tuning. As a result, the research of database monitoring and tuning system with graph UI is very hot.There are three system needs from different aspects are proposed by real world status. Those needs are general system needs, functional needs and none functional needs. By monitoring and tuning system, staffs can not only deal with system surveillance works but also tune the system performance. Thus, the database administrator’s daily work can be simplified by the dynamic graphic system. Moreover, tuning the system in time can help improve system stability by prevent database running in a high working load.Then, the architecture of this system is presented, which is based on server application and agent program. The system consists of database monitoring and optimization server side application and target side agent program. In addition, Database performance monitoring and performance analysis are the core business of the system. During system design part of this paper, the design and implemantation of system database, server application and agent program is presented. Also the UI design is demonstrated. Lastly, all the functions within this design are proved by the system test.This design combines Oracle database management knowledge and web server programming technology together. By taking the advantages of B/S(browser and Server) architecture and the ability of presenting graphs in web browser, IT staffs can be free from using those boring commands, and junior staffs’ maintenance and tuning skill can be rapidly improved at mean time. |
