Re: Oracle Streams Queues
- From: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
- To: stalinsk@xxxxxxxxx
- Date: Thu, 18 Sep 2008 09:32:44 +0700
stalinks,
in streams there is "subset table rule" which match for your case
--
thanks and regards
ujang | oracle dba
jakarta | http://ora62.wordpress.com
On Wed, Sep 17, 2008 at 11:40 PM, Stalin <stalinsk@xxxxxxxxx> wrote:
> 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:
