The Oracle version is 9.2.0.3 on Solaris 8 on
a E4500 with 2GB RAM.
rhudli_at_acm.org (Raghu V. Hudli) wrote in message news:<b9202043.0307141721.2ecd7516_at_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 Tue Jul 15 2003 - 03:18:27 CDT
