Development And Implementation Of Oracle Database Monitoring System

With the continuous development of science and technology, database technology has become the foundation and core of the modern computer information systems and application systems. Though its function has been increasingly valued by employees, the problems of the database management and performance tuning, monitoring accompany. After having been on line for a period, most database systems might have performance problems which may be caused by the change of the amount of data stored, or by concurrent access to the database and so on.Due to the complexity of the database system itself, while tuning the database involves multiple aspects of the network, hosts, storage, etc., that undoubtedly lead to difficulty in database management and database adjustment. Therefore a database monitoring and management system is needed. This paper is about the research and solution of this issue.On the basis of understanding the current situation at home and abroad, the paper firstly introduces the basic theory related to the Oracle database knowledge, including system structure of Oracle database, and then analyzes the monitoring object of database monitoring system. Aiming at the problems to study and solve, this paper focuses on analyzing the demands of database monitoring system, and proposes the structure of a database monitoring system, divides the function module of database monitoring system, presents the design and realization of each function module in detail. Finally, the performance of the designed database monitoring system is tested, and the test results show that the design of the database monitoring system has good stability and reliability.