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

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.
+40213212243



--
http://www.freelists.org/webpage/oracle-l