基于AWR报告的数据库性能的研究

Database Performance Research Base on AWR Report

随着大数据时代的发展,海量数据对数据库产生的性能问题不容小觑,快速诊断出数据库的性能问题尤为重要。借助决策树算法的ID3算法、JSOUP解析器、DOM4J技术、线程池技术对Oracle数据库的AWR报告进行数据分析、模型转化、决策树构建,最终实现将AWR报告导入系统自动分析得出Oracle数据库的性能问题,节省了人工解读的时间。

With the development of the big data era,the performance problems caused by massive data to the database cannot be underestimated.It is especially important to quickly diagnose the performance problems of the database.With the aid of ID3 algorithm of decision tree algorithm,JSOUP parser,DOM4J technology,and thread pool technology,the AWR report of the Oracle database was used for data analysis,model transformation,and decision tree construction.Finally,the AWR report was imported into the system to automatically analyze the performance of the Oracle database Problem,saving time for manual interpretation.