针对Linux与Oracle的多服务器图形对比监控系统

Charting system for comparing multiple Linux and Oracle servers

为了监控并调优基于Linux的Oracle数据库群集,Linux和Oracle的性能数据都需要包含在内,除此以外,多台服务器性能的对比,以及Oracle集群相同事件的对比,都是必要的,但已有系统都无法方便地完成此任务。提出一系列与性能、流量、历史事件等相关的数据采集方法;利用脚本语言周期性地处理采集的数据并把结果数据集载入数据库系统;设计网页交互系统获取用户查询指令,后台利用RRDTool工具生成数据对比的图形化走势图。通过该系统与Oracle企业管理器得到系统运行性能对比分析报告。

For monitoring and tuning multiple Oracle database systems based on Linux,Linux and Oracle should both be involved,Comparing related performance and issues upon multiple servers is necessary,which is not convenient to achieve in existing monitoring system.In this paper,a series of methods are put forward to collect data associated with performance,I/O traffic,history events,etc.Scripting language is utilized periodically to sort out relevant data,as well as to load data into database system.A Web-based interactive system is constructed to classify and demonstrate record result which has been processed by RRDTool,so that schematized data including comparison diagram and trend chart is set up.The performance analysis is generated upon the comparison between this system and Oracle enterprise manager.