Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: bulk binds with AQ

Re: bulk binds with AQ

From: Seth <sgelberg_at_optonline.net>
Date: 29 Aug 2001 18:14:11 -0700
Message-ID: <f3159b28.0108291714.51710614@posting.google.com>


I have this proc that takes 12 seconds to update 1600 rows and enque 1600 messages(sendmsg is my enque procedure that calls oracles dbms_enque).

Galen Boyer <galenboyer_at_hotpop.com> wrote in message news:<ur8tueffv.fsf_at_verizon.net>...
> On 29 Aug 2001, sgelberg_at_optonline.net wrote:
>
> > a regular update executes in 1-2 seconds....
>
> Okay.
>
> What's this do?
>
> hsp_utilities.SendFixMsg(hsp_utilities.v_fixQueOut, v_fixRec, '8');
Received on Wed Aug 29 2001 - 20:14:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US