Oracle Streams Queues
Date: Wed, 17 Sep 2008 09:40:00 -0700
Wondering if anyone could chime in with the experience in implementing streams. We have a table wherein each subset of data needs to be replicated to different databases for e.g rows of type x to database A and rows of type y to database B and so on. Question is should i have separate capture queue for each subset data on source database or one queue and deal with routing data to appropriate destination apply queues in propagation process. i don't want to do filtering or processing on the destination queues, as the databases would be busy processing other requests. Are there any performance issues of having many capture queues on source database?