Oracle Streams Queues
- From: Stalin <stalinsk@xxxxxxxxx>
- To: "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 17 Sep 2008 09:40:00 -0700
All,
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?
Thanks
Stalin
--
//www.freelists.org/webpage/oracle-l
Other related posts:
