huge stream latency
jeffhanApr 3 2010 — edited Apr 27 2010i had a testing streaming environment set up just for preparation the real production one. The configuration was pretty fine, however the replication is experiencing huge latency:
source server: Oracle RAC 10gR2 two nodes (local capture, queue-to-queue propagation)
destination server: Oracle 10gR2 standalone server.
Stream is on Schema level. The environment is a testing environment so there are not much load on these servers. However every time i insert some data into table (just few rows <10) on source server, it will get replicated on destination schema at least more than 1 hour.
is that anyway to detect will the bottleneck is? i even adjust the propagation latency parameter to 0, the issue still exists. i checked all the alert log, there are no errors there at all.
Thanks for the help!