Author Login Editor-in-Chief Peer Review Editor Work Office Work

Computer Engineering ›› 2009, Vol. 35 ›› Issue (10): 54-56. doi: 10.3969/j.issn.1000-3428.2009.10.017

• Software Technology and Database • Previous Articles     Next Articles

Design and Implementation of Oracle Monitoring and Processing System

LIU Feng-long   

  1. (Information Center, Hunan Institute of Humanities Science and Technology, Loudi 417000)
  • Received:1900-01-01 Revised:1900-01-01 Online:2009-05-20 Published:2009-05-20

Oracle监控处理系统的设计与实现

刘凤龙   

  1. (湖南人文科技学院信息中心,娄底 417000)

Abstract: In order to guarantee the continuous and efficient performance of Oracle databases, a CORBA-based Distributed Oracle Monitoring System(CDOMS) is designed and implemented. “Agent plus oracle view surface” is used in CDOMS, and flexible configuration, two-level based content presentation and prediction techniques are adopted in CDOMS adopts to achieve cost-efficient monitoring. It is proved experimentally and practically that CDOMS can continuously monitor distributed Oracle database system and server’s resource with different granularities in real-time, alarm for potential faults in advance, analyze the database system comprehensively and manage the remote nodes effectively. Experimental result and the actual application of nomenclature project prove effectivity of the system.

Key words: Oracle, monitoring, server resources, CDOMS system, malfunction

摘要: 针对Oracle数据库的有效监控问题,提出一个基于CORBA的分布式Oracle监控处理系统。系统采用“代理+Oracle视图”技术,通过灵活的监控策略配置、多层次多粒度内容呈现等方法,实现对物理上分布的多个Oracle数据库进行不间断的集中式监控、分析处理和故障分析预警等功能,采用预测模型方法有效降低监控引起的网络流量。实验结果和型号项目中的实际应用验证了系统的有效性。

关键词: Oracle数据库, 监控, 服务器资源, CDOMS系统, 故障

CLC Number: