Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 3051 invoked from network); 17 Sep 2008 23:15:46 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by air964.startdedicated.com with SMTP; 17 Sep 2008 23:15:45 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9AF2B9C29F3; Wed, 17 Sep 2008 22:34:59 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20181-01; Wed, 17 Sep 2008 22:34:59 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8133F9C28D6; Wed, 17 Sep 2008 22:34:56 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 17 Sep 2008 22:32:48 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F19BB9C22E0 for ; Wed, 17 Sep 2008 22:32:47 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19659-03 for ; Wed, 17 Sep 2008 22:32:47 -0400 (EDT) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.173]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 05EE39C1530 for ; Wed, 17 Sep 2008 22:32:45 -0400 (EDT) Received: by ug-out-1314.google.com with SMTP id x30so611687ugc.11 for ; Wed, 17 Sep 2008 19:32:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=K1TW6mj3P2iBbhsGG+qdFppKeVUKHGh5zqZYCINs/gY=; b=JiyixvixFM/HUNb7myY7KBuK39zZNtGp5dap4VvHiJ9SWVkIiW6M0qh8XUftParp3k 53S8zWYWAP5V0n9OiRv51GE5VCMPVU6ry2CGLqwkRsmUPVXSVfMFZ07afzeAGLwwbLo0 BdsYbx/Mky8cZ1Wz4fHuCwfAbjxHt4wDtkL7c= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=vaJbli6HTGCwlTr8r0E/tC6nkmkAboE08z6iwNvGgh4bRVcZ/D0U5zGQqgmfSadotC OPpVlg6L3B+zlp4vLp7VAv3XGSYP7nm+72aTcYo3rlOctcz3lloUzpmVbkimFyxnrDwM uoELVomZQsLat3jCIkTJlu7KqAgC9wbzLkqYg= Received: by 10.210.48.14 with SMTP id v14mr1687848ebv.38.1221705164921; Wed, 17 Sep 2008 19:32:44 -0700 (PDT) Received: by 10.210.78.14 with HTTP; Wed, 17 Sep 2008 19:32:44 -0700 (PDT) Message-ID: <3edcb66e0809171932m254b31b1y83ff6b380e392c5b@mail.gmail.com> Date: Thu, 18 Sep 2008 09:32:44 +0700 From: "Ujang Jaenudin" To: stalinsk@gmail.com Subject: Re: Oracle Streams Queues Cc: "Oracle Discussion List" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-archive-position: 10902 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: ujang.jaenudin@gmail.com Precedence: normal Reply-to: ujang.jaenudin@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain 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 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 -- http://www.freelists.org/webpage/oracle-l