In this day and age of rapid global informatization, massive data explosion has raised great challenges to the performance of databases, influencing industrial production. Ensuring the database works efficiently and reliably has become a key concern while the volumes of data are growing so rapidly. Good database management, therefore, means that the administrators must be quite experienced and knowledgeable enough to find performance problems in a database and eradicate them in the shortest time possible so that disruptions to an industrial process and inefficiency will not take place. The following presents an intelligent approach to an in-depth analysis using ID3 algorithm, the parsing tool of JSOUP, and other advanced technologies of performance indicators from an Oracle database. The methods used in this paper will illustrate how performance bottlenecks can be precisely located in Oracle databases, helping administrators find and eliminate the root cause of performance problems with limited experience. It reduces the work of manual interpretation and further assures efficient and reliable database operations to facilitate smooth progress in industrial production during informatization.

错误:搜索内容不能为空,请输入英文关键词
错误:关键词超出字数限制,请精简
高级检索

Design and Implementation of an Automatic Diagnostic System for Oracle Database Performance Issues Based on the AWR Algorithm

  • Zhongqi Zhu

摘要

In this day and age of rapid global informatization, massive data explosion has raised great challenges to the performance of databases, influencing industrial production. Ensuring the database works efficiently and reliably has become a key concern while the volumes of data are growing so rapidly. Good database management, therefore, means that the administrators must be quite experienced and knowledgeable enough to find performance problems in a database and eradicate them in the shortest time possible so that disruptions to an industrial process and inefficiency will not take place. The following presents an intelligent approach to an in-depth analysis using ID3 algorithm, the parsing tool of JSOUP, and other advanced technologies of performance indicators from an Oracle database. The methods used in this paper will illustrate how performance bottlenecks can be precisely located in Oracle databases, helping administrators find and eliminate the root cause of performance problems with limited experience. It reduces the work of manual interpretation and further assures efficient and reliable database operations to facilitate smooth progress in industrial production during informatization.