| 针对Linux与Oracle的多服务器图形对比监控系统 |
| |
| 引用本文： | 江竟敏,黄忠东.针对Linux与Oracle的多服务器图形对比监控系统[J].计算机工程与应用,2011,47(7):128-130. |
| |
| 作者姓名： | 江竟敏 黄忠东 |
| |
| 作者单位： | 浙江大学计算机科学与技术学院,杭州,310027 |
| |
| 摘 要： | 为了监控并调优基于Linux的Oracle数据库群集,Linux和Oracle的性能数据都需要包含在内,除此以外,多台服务器性能的对比,以及Oracle集群相同事件的对比,都是必要的,但已有系统都无法方便地完成此任务。提出一系列与性能、流量、历史事件等相关的数据采集方法;利用脚本语言周期性地处理采集的数据并把结果数据集载入数据库系统;设计网页交互系统获取用户查询指令,后台利用RRDTool工具生成数据对比的图形化走势图。通过该系统与Oracle企业管理器得到系统运行性能对比分析报告。
|
| 关 键 词： | Oracle数据库 Linux 性能数据 图形化 RRDTool工具 |
| 修稿时间： | |
Charting system for comparing multiple Linux and Oracle servers |
| |
| JIANG Jingmin,HUANG Zhongdong.Charting system for comparing multiple Linux and Oracle servers[J].Computer Engineering and Applications,2011,47(7):128-130. |
| |
| Authors: | JIANG Jingmin HUANG Zhongdong |
| |
| Affiliation: | College of Computer Science and Technology,Zhejiang University,Hangzhou 310027,China |
| |
| Abstract: | 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. |
| |
| Keywords: | Oracle Linux performance data schematize RRDTool |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
| 点击此处可从《计算机工程与应用》浏览原始摘要信息 |
|
点击此处可从《计算机工程与应用》下载全文 |
|
