Re: Performance of Oracle AQ (Advanced Queueing)

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 - 07:38:54 CST