Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Advanced queueing question
Hi all,
Environment is:
Oracle 8.1.7.3
AIX 4.3.3
RS6000 hardware
We've recently had a major upgrade to an application and the application vendor has started making extensive use of Oracle's Advanced Queueing. My knowledge of this topic is next to nothing and I'm doing some reading now to try and get up to speed.
In the meantime I wonder if anyone can comment on a possible performance issue in respect of AQ?
The application users have complained of "poor performance" ever since the upgrade. The application uses a three-tier architecture with the client essentially just a browser and the middleware and database located on the server. I'm using statspack as one tool in my endeavours to find out if there really is a problem. I notice that the "queue messages" event is usually at the top of the "Top 5 Wait Events" section of a statspack report. To quote an example, in a 5.5 hour sample the queue messages event clocked up statistics thus:
Avg Total Wait wait Waits Event Waits Timeouts Time (cs) (ms) /txn ------------------ ------------ ---------- ----------- ------ ------ queue messages 54,422 21,558 25,678,484 4718 0.2
My question is: Is this "normal", or does this represent real waiting by users?
There are 36 job queue processes kicked off when the database is started, if that is relevant to this.
Many thanks for any input.
Regards,
Tim Kearsley
HBS
Received on Mon Mar 08 2004 - 08:55:37 CST