Forum Stats

  • 3,816,532 Users
  • 2,259,202 Discussions


AQ monitoring

3004 Member Posts: 204,171 Green Ribbon
We are using AQ in a very simple way - a number of queues are generated and external
applications enqueue and dequeue events in the conventional way.

I'm after a way of monitoring the throughput
on these queues, preferably a graphical tool. I can find no documentation on how to do this with the Oracle client tools that come with Enterprise.

Has anyone any hints on how this might be done? Using the Workload generator for example?

Many thanks.

Giles Nelson.


  • 3004
    3004 Member Posts: 204,171 Green Ribbon
    I dont think there is any Graphical tool currently that can give you throughput details.

    There are some statistical data available in some views for propagation, though. You can also take a look at GV$AQ for some more queue statistics.

    If you are using propagation, you can get some statistics about the differnt schedules in dba_queue_schedules or user_queue_schedules view.
This discussion has been closed.