Home > database >  Ogg extraction time delay 5 to 10 seconds
Ogg extraction time delay 5 to 10 seconds

Time:10-23

The oracle 11.2 g
Ogg 11 g and tested 12 g
Win2008



The reference configuration document
https://blog.51cto.com/pimg2005/2133820

1, MGR. PRM

The PORT 7809


2, ext_w1 PRM

Extract ext_w1

Userid ogg, password oracle

Exttrail D: \ \ dirdat \ app \ ogg wt
Dynamicresolution
Table YIKE. Zm_whereconfig;



After each update table, found that 5 to 10 seconds to appear trai file modification time, so I decided that the problem is extraction time is too long, the database table 300 data, other tables are not updated, testing library,

Testing for many times, on both sides of data synchronization time is 5 to 10 seconds, I can accept up to 1 seconds, has been studying for two days, has to do, for a great god, the younger brother, appreciate



CodePudding user response:

Bad disk IO performance,
Suggest another with Linux system, may be better!
  • Related