Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: bulk binds with AQ
On 28 Aug 2001 15:29:01 -0700, sgelberg_at_optonline.net (Seth) wrote:
By itself, how long does this take? Assuming you are not doing the send message?:
> UPDATE IOI
> SET status = 'E'
> WHERE (status = 'A' OR status = 'V' OR status = 'M') and
>(expire_time <=
>v_curTime)
> RETURNING ioi_id, symbol, side, ord_type, clordid, order_qty,
>sender_comp_id, sender_sub_id,
> on_behalf_comp_id, on_behalf_sub_id, echo_text
> BULK COLLECT INTO v_ioiTab, v_symbolTab, v_sideTab, v_ordTypeTab,
>v_clordidTab, v_orderQtyTab, v_sciTab, v_ssiTab,
> v_obciTab, v_obsiTab, v_echoTextTab;
Also:
> hsp_utilities.SendFixMsg(hsp_utilities.v_fixQueOut, v_fixRec,
>'8');
what type of queue is this? Multi-recipient (publish-subscribe)? Or simple? Is your queue table in tablespace SYSTEM?
Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam
Received on Wed Aug 29 2001 - 06:21:08 CDT