基于用电信息采集系统的Oracle GoldenGate性能优化方法

Oracle GoldenGate Performance Optimization Methods Based on Electric Energy Data Acquire System

针对用电信息采集系统中,Oracler GoldenGate源端数据不能及时同步到目标端,导致数据延迟的问题,从抽取进程、传输进程、复制进程等方面介绍Oracler GoldenGate的性能优化方法,认为必须深入分析业务系统的数据特性,合理的拆分进程,才能真正解决Oracler GoldenGate的数据同步性能问题。

With the constant improvement of the informatization and automation degree of the electric power industry, the efficiency of the data synchronization, copy and distribution among different business systems becomes Ihe problem which practitiomrs have to face. The Oracle Golden（;ate software plays a key role in data synchronization of electric energy data acquire system which has large amount of data and many external business interfaces, and underlakes the obligation of the bottom data acquisition and statistical tasks in power industry, This paper combines the practical operation and maintenance expcrience of Oracle GoldenGate software, and summarized the performance optimizatioa methods of Oracle GoldenGate.