Re: bulk binds with AQ

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 28 Aug 2001 23:22:05 -0500
Message-ID: <u66b79vqy.fsf@verizon.net>

On 28 Aug 2001, sgelberg_at_optonline.net wrote:

> 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).
>
> I'm wondering if anyone has any suggestions for improving the
> performance of this proc

Forgetting about updating, what's the performance of this query like?

SELECT ioi_id, symbol, side,  ord_type, clordid, order_qty,
       sender_comp_id sci, sender_sub_id ssi,
       on_behalf_comp_id obci, on_behalf_sub_id obsi, echo_text

    FROM ioi
    WHERE (status = 'A' OR status = 'V' OR status = 'M') and

          (expire_time <= v_curTime);

-- 
Galen Boyer
It seems to me, I remember every single thing I know.

Received on Tue Aug 28 2001 - 23:22:05 CDT