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

54Oracle(417000)OracleCORBAOracle+OracleOracleOracleCDOMSDesignandImplementationofOracleMonitoringandProcessingSystemLIUFeng-long(InformationCenter,HunanInstituteofHumanitiesScienceandTechnology,Loudi417000)AbstractInordertoguaranteethecontinuousandefficientperformanceofOracledatabases,aCORBA-basedDistributedOracleMonitoringSystem(CDOMS)isdesignedandimplemented.“Agentplusoracleviewsurface”isusedinCDOMS,andflexibleconfiguration,two-levelbasedcontentpresentationandpredictiontechniquesareadoptedinCDOMSadoptstoachievecost-efficientmonitoring.ItisprovedexperimentallyandpracticallythatCDOMScancontinuouslymonitordistributedOracledatabasesystemandserver’sresourcewithdifferentgranularitiesinreal-time,alarmforpotentialfaultsinadvance,analyzethedatabasesystemcomprehensivelyandmanagetheremotenodeseffectively.Experimentalresultandtheactualapplicationofnomenclatureprojectproveeffectivityofthesystem.KeywordsOracle;monitoring;serverresources;CDOMSsystem;malfunctionComputerEngineering3510Vol.35No.1020095May2009··10003428(2009)10005403ATP311.131[1]OracleCORBA(CORBA-basedDistributedOracleMonitoringSystem,CDOMS)724hCDOMSCPU2OracleDBAStudio,OEM[2],QuestCentral[3]OracleI/O[4]OracleJ2EE[5]Oracle3CDOMS3.12APIOracleOracleCDOMS+1OracleCORBA1CDOMS([2006]171No.165)(1971)[e-mail]55CDOMSC/SNodeManagerOracleCORBA3.2CDOMS2OracleOracle2CDOMS(1)21)2)OracleCPU/(2)21)2(differentiation)()2)(3)21)2)GUI3.33.3.1OracleOraclev$v$sessionv$sess_ioI/OOracleOracleCDOMSOracle3.3.2APICDOMSCOM/DCOM,J2EECORBACORBACDOMSCORBACORBA2.3VisiBrokerAPIIDLinterfaceServerAgent{voidgetSumInfo(outSumInfosummaryInfo);//voidgetMemInfo(outMemInfomemoryInfo);//booleangetValidDrives(outDrivesdrvs);//booleangetDiskInfo(instringfilesystem,outDiskInfodiskinformation,inoutunsignedlongflag);//ProcessSequencegetProcessInfo();//booleangetDiskUsage(outDiskUsagedusage);//voidgetNetworkInformation(outNTISequencensequence);//ProcessPortSequencegetPortInformation();//};CPUI/O3.43(1)OracleMonitor(2)HostMonitorNodeManagerNodeManager(3)NodeManager56(CPU)(4)DBMonitorOracle(5)SysInfoDBinfoHostInfoSysInfoDBInfoHostInfoCPU(6)TjcThread(7)TjcReportThreadhtml(8)WarnAnalysis(9)WarnGenerator(10)ProcessorSysConfDBMonitorHostMonitorNodeManagerOracleMonitorSYSInfoDBInfoHostInfoWarnGeneratorWarnAnalysisSysConfProcessorTjcThreadTjcReportThread3CDOMS4CDOMSCDOMSOracle4.1CDOMS(1)(2)CPU(3)(4)4.2CDOMS3[6](StaticModel-SM)(LinearModel,LM)(AccelerationModel,AM)SMfi,jp(t)=fi,j(ti,jprev)LMfi,jp(t)=fi,j(ti,jprev)+vi,jti,jAMfi,jp(t)=fi,j(ti,jprev)+vi,jti,j+(ti,j)2ai,j4.3CDOMS5CDOMSCDOMS3PC12Oracle10gPCCPU2.0GHz1GB120GB2OracleCDOMS5.115s2CPU(1)10MB(2)APICPU1%(3)OracleCPU4%5.2CPU4010203040503634323028260/MB0102030405010080604020CPU/(%)(a)(b)CPU4CPU(59)