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

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Wed, 23 Feb 2005 08:40:39 -0800 (PST)
Message-ID: <20050223164039.73269.qmail@web52607.mail.yahoo.com>

Hi Paul,

I am using AQ in high volume transactions systems.

Oracle AQ is based around the IOT table. So there is some overhead of PL/SQL API around normal Oracle INSERT, UPDATE, SELECT, ...

But it is very nice, very transactional and you have so many nice features around.

Did you mean 200 per second per CPU?
I assume you were thinking about 200 on 1 CPU machine.

The speed will depends on your usage, but 200 is possible. If you can use 10g then you have bulk AQ operations similar to bulk (array) DML.

Regards,
Zoran

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.
>
> Thanks,
> Paul
> --
> http://www.freelists.org/webpage/oracle-l
>

Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail

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

Received on Wed Feb 23 2005 - 11:43:40 CST