We are testing using AQ streams with JMS as the consumer on 10.2.0.2.0.
We are having performance problems on the dequeue side. We are
currently able to run approximately 2000 transactions per second on an
hp/ux 3440 box with 4 cpu's and 8G of memory. After that the cpu's
become a bottleneck. Both the enqueing and dequeing are on the same
box. We have 1 enque table with 30 threads(processes) and a trigger to
populate an intermediate queue table, we have 10 deque tables with 20
threads (processes). We have tried a few of the performance tricks from
the docs but nothing seems to be able to reduce the amount of cpu that
gets used. Has anyone experienced something similar? Any suggestions
would be welcome. The sga is configured with 2.6G of memory, we've
tried bumping it up to 4 but the box seems to use more swapfile then
with little gain in AQ performance.
Thanks,
George
Received on Wed May 03 2006 - 14:36:18 CDT
