1 Reply Latest reply: Jul 30, 2010 6:36 PM by phcullen-Oracle RSS

    Performance issue with AQ

    754984
      Hello there,

      Iam enqueueing with the rate of 80 msg/sec. But I can see the below query
       select   /*+ FIRST_ROWS */  t1.owner, t1.name, t1.queue_table, t1.queue_type, t1.max_retries,
                     t1.retry_delay, t1.retention, t1.user_comment, t2. type , t2.object_type, t2.secure
      from  all_queues t1, all_queue_tables t2
      where  t1.owner=:1 and  t1.name=:2 and  t2.owner=:3 and  t1.queue_table=t2.queue_table    
      getting executed very frequently. Iam using Oracle JMS ADT message payload with no receipient list. Not sure when it is getting executed. How to tune this. Iam using JMS template to send messages.

      Can anyone help to tune this since it is hitting DB very hard (200 times/sec) and eating up CPU.

      Thanks in advance.