From oracle-l-bounce@freelists.org Fri Dec 9 14:03:48 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jB9K3mSI022508 for ; Fri, 9 Dec 2005 14:03:48 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id jB9K3iAX022494 for ; Fri, 9 Dec 2005 14:03:44 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 575232502C7; Fri, 9 Dec 2005 15:03:36 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25630-01; Fri, 9 Dec 2005 15:03:36 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D12E9250283; Fri, 9 Dec 2005 15:03:35 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 09 Dec 2005 15:03:35 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 95193250295 for ; Fri, 9 Dec 2005 15:03:35 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25599-06 for ; Fri, 9 Dec 2005 15:03:35 -0500 (EST) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.200]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 648C3250283 for ; Fri, 9 Dec 2005 15:03:35 -0500 (EST) Received: by wproxy.gmail.com with SMTP id i24so978655wra for ; Fri, 09 Dec 2005 12:03:35 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=cJhTG8MQF6rX445v/H0hPxMNAv7BmCgAuMoowHVjsupdjHrjVliVF+cx9AFxXdkhWVEntmxPScij52+LdMZm7J80NXn90U+F5M8ViSB9Oi+EsFcROK52bXAJTZKweacFDMfCBKrkBLKvivXOzrfY/LLtth1o7mjASyxmzG/dx10= Received: by 10.65.157.15 with SMTP id j15mr3711119qbo; Fri, 09 Dec 2005 12:03:34 -0800 (PST) Received: by 10.65.152.12 with HTTP; Fri, 9 Dec 2005 12:03:34 -0800 (PST) Message-ID: <52a152eb0512091203sad33ce3jda489b1b44de3ae4@mail.gmail.com> Date: Fri, 9 Dec 2005 15:03:34 -0500 From: Christo Kutrovsky To: cstephens16@gmail.com Subject: Re: event based scheduling and queues Cc: Oracle-L Freelists , Bill Myers In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-Disposition: inline References: X-archive-position: 29069 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: kutrovsky.oracle@gmail.com Precedence: normal Reply-To: kutrovsky.oracle@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Not scanned: please contact your Internet E-Mail Service Provider for details X-MailScanner-From: oracle-l-bounce@freelists.org Can you give us more details about how you enque and make the job wakeup ? Perhaps some code extracts ? On 12/9/05, Chris Stephens wrote: > 10gR2 on linux > > We have a queue that accepts xml documents. Documents are members of > sets. No document can be processed unless the entire set has been > enqueued. We indicate this by a 'isLastInSet' attribute in the > payload. We were hoping to set an event based job that is triggered > this attribute having a 'true' value. > > In testing this out we discovered that events can be ignored when the > job that wakes up is already active. We ran a loop that enqueued > 20,000 items that all had isLastInset = 'true'. The action in the job > was to simply insert a row into a table. After executing the test, > there were only 224 rows inserted. This obviously leaves open the > possibility that many items will be left unprocessed. > > We need a solution that ensures all sets are processed as soon as the > last set member is enqueued. > > Has anyone had similar requirements? ...and if so, what was the > implementation? did you have a polling process that wakes up every so > often and evaluates the entire queue? > > thanks, > chris > -- > http://www.freelists.org/webpage/oracle-l > > > -- Christo Kutrovsky Database/System Administrator The Pythian Group -- http://www.freelists.org/webpage/oracle-l