Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

huge stream latency

jeffhanApr 3 2010 — edited Apr 27 2010
i 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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2010
Added on Apr 3 2010
16 comments
3,541 views