Re: Performance of Oracle AQ (Advanced Queueing)

Depends on a whole range of factors, but with small message sizes, and a perfect world, we have been able to push through numbers in the low thousands per second. Perfect world means you probably won't reach this in real life, but you can certainly expect 100's per second with aggressive tuning.

Pete

dellera_at_my-deja.com wrote:

> Pete,
>
> many thanks for your answer. Our tuning group will
> by sure make use of your kind suggestions. We can't
> work on the hardware side (we already use RAID but
> not from EMC) but surely we can try LGWR tuning
> and striping, as far as better business design.
>
> But - since we are just starting using AQ, we
> presently have no figure about the actual
> throughput which we could expect. Some guy on
> this newsgroup suggested (by "feeling") a figure
> of 10/100 messages per second (per queue).
> Is this the order of magnitude we have to expect ?
> With or without aggressive tuning ?
>
> To further elaborate: in principle, since AQ is based
> on tables, one could expect performances similar to
> that of ordinary table insertion/deletion.
> But DBMS_AQ is written by experienced PL/SQL
> Oracle developer; this could lead to _better_
> performances, both because of their knowledge
> of Oracle internals and their careful
> analysis of the problem.
>
> Many thanks to everybody who will provide
> any information. Again, I will post the
> results of our own benchmarks - as soon as we
> will make them - if anyone is interested.
>
> Alberto
>
> ---
> Pete Sharman <psharman_at_us.oracle.com> wrote:
>
> > Alberto
> >
> > We've done a lot of performance testing of AQ with the consulting
> group
> > I'm in with Oracle, and it's possible to get quite high throughput if
> > you play with a few things:
> >
>
> <SNIP>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Received on Mon Nov 01 1999 - 10:23:34 CST