Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle Advanced Queue and Java Messaging System(JMS)

Re: Oracle Advanced Queue and Java Messaging System(JMS)

From: Radu-Adrian Popescu <>
Date: Mon, 11 Apr 2005 21:20:49 +0300
Message-ID: <>

Martic Zoran wrote:
> We do AQ and it is the main part of one big product in
> my company.
> It is working fine, very fast. Faster then the
> products we integrate with :)

Can you share some numbers ? What are the average enqueue and dequeue speeds, and on what hardware ?
Also how many queues, producers and consumers do you have ?

> But of course it is mainly because AQ is made around
> something that is working fine in Oracle for a long
> time: tables and PL/SQL :)
> With addition to object types that may define message
> types if raw message type is not used.

Does this mean that you're storing raw messages ?

> Did not have the chance to try bulk AQ operations that
> are available from 10g and making bulk DML into the
> main table.
> The code is mainly in PL/SQL, but also have a lots of
> C++ code interactions with the queue.
> We are using just C OCI, because C OCI is with all
> functionality from the beggining.
> OCCI is pretty new thing and I think OCCI for AQ is
> available only from 10g, but not so sure.

Yes, OCCI for AQ came with 10g. Forgot.

> I will believe in AQ technology, because many other
> things are built on top of it important to Oracle,
> like: Streams, Workflow(?), JMS, ...
> That is why Oracle needs to improve AQ and improved it
> a lot with bulk DML, bulk enqueue/dequeue operations
> from the performance point of view.
> Regards,
> Zoran

Cheers and thanks in advance,

Radu-Adrian Popescu
CSA, DBA, Developer
Aldrapay MD
Aldratech Ltd.

Received on Mon Apr 11 2005 - 14:24:48 CDT

Original text of this message