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 -> Help with AQ Performance Problems

Help with AQ Performance Problems

From: Raghu V. Hudli <rhudli_at_acm.org>
Date: 14 Jul 2003 18:21:30 -0700
Message-ID: <b9202043.0307141721.2ecd7516@posting.google.com>


Hello,

We are using Oracle AQ as a message delivery/store mechanism in a web application. We migrated from a SMTP/IMAP solution so that the AQ solution would be more scalable and also secure. We have created multiple queues and "assigned" multiple users to each queue so that the load on the queues is balanced to some extent. When a message needs to be delivered, we just enqueue it. When a message needs to be read, we browse the queue. We are using JMS interface. The application message headers - like folder type, the recipient's id, subject, status of message (read or unread), etc. are stored as properties in the JMS message. For a particular user, we open the queue in browse mode by specifying the message headers in the selector. To get the list of messages for the user (specified with the selector) it is taking between 11-40 seconds depending on how many messages are in the queue. Please note that there are messages for other users too (recipient id in the properties. Since we are using JMS message properties, we are not able to create indexes based on the properties to speed up performance. Lately, we are also seeing performance degradation in the enqueue operation. We also used the PL/SQL interface outside of our application talking to AQ directly; that did not help either. We are using Oracle OCI driver to connect to the database.

Any help/suggestions that we receive will be highly appreciated.

Best regards,

Raghu Received on Mon Jul 14 2003 - 20:21:30 CDT

Original text of this message

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