Wait Event Based Tuning Oracle Databases And Real-time Monitoring System

As information technology continues to evolve with the application in the enterprise continues to expand the database as data storage and management software system, its role is increasingly valued by professionals, accompanied by the database management and performance tuning, monitoring problem. As the complexity of the database system itself, to database management and adjustment had no small difficulty. Therefore, how to find an efficient, accurate method of database tuning, and when problems arise in the database to detect and deal with, has become a hot issue.Around the need to study and solve problems in understanding the basis of the status quo at home and abroad, this article introduces the basic theories related to Oracle database knowledge, research and analysis of database performance optimization goals, optimization stage and the common tuning methods, including optimization for index , query optimization, table optimization, and database connection parameters optimization. At the same time the analysis of performance bottlenecks of conventional detection methods and their lack, including the presence of missing performance bottleneck, the performance is not easy to locate faults and other problems, based on the introduction of the wait events, wait for the event studied in detail the principles of classification and localization performance bottlenecks in database application, combined with specific problems encountered, explained how to use wait event means to locate the bottleneck performance issues, while waiting for events using detailed information to exclude database performance problems.To study and address this problem, focus on database monitoring system requirements of the analysis, a database monitoring system architecture, in order to enable monitoring system to monitor the process on the fault occurred are given to solve programs, introduced expert systems thinking. In the analysis of expert system knowledge based on the monitoring system for database characteristics and needs of the monitoring system for use in an expert system type of expert system ideas presented in the database specific implementations.This article describes the subsequent detailed design of a database monitoring system and implementation process, including database design and user interface design, and database monitoring part and host part of the implementation monitoring, and implementation of the system were tested.Finally, the database design optimization techniques and database monitoring system were summarized, analyzed the existence of this design still need improvement.