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

  • From: Alexander Gorbachev <gorbyx@xxxxxxxxx>
  • To: paulvallee@xxxxxxxxx
  • Date: Thu, 24 Feb 2005 20:48:19 +0100


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.


On Wed, 23 Feb 2005 11:35:37 -0500, Paul Vallee <paulvallee@xxxxxxxxx> 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.

Other related posts: