Re: Experiences with AQ with a very high concurrent workload solicited

Paul,

One of your biggest problems would be amount of redo logs, so be prepared to handle it. IOT maintenance will take a lot depending on the usage pattern.

In our experience multi-consumer queues are not working well in 9i so we are trying to avoid them whenever possible. In general, there are quite a few bugs in 9i with AQ.

We have a heavy application working with queues... I cannot say what is the rate of pure queues transaction but from middle tier app point of view there are up to 500+ tps in peak time. Application has complex logic, so there might be more (or less) operations with queues themselves. We are on HP-UX if it matters.

HTH,
Alex

On Wed, 23 Feb 2005 11:35:37 -0500, Paul Vallee <paulvallee_at_gmail.com> wrote:
> Hello,
>
> We have a client that is considering replacing SonicMQ with Oracle AQ
> for an application that currently does up to 200 messages per second
> and needs to scale well significantly beyond that.
>
> We have AQ experience with some applications that did 400 messages per
> minute but that's a far cry from 200 per second (12000/minute).
>
> If anyone has experience with Oracle AQ under this kind of workload I
> would love to hear of them.

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