0 Replies Latest reply: Feb 17, 2012 1:07 PM by user154136 RSS

    _L Adavnced Queue Table

      We have a multi consumer 8.1 compatiable AQ setup and we are seeing the query below running constantly during our dequeue processes. Is anyone familar with the _L table in AQ ? i checked the documentation and I could not get any information about it. We are salso seeing high CPU utilization which is being cuased by this query being ran so many times from multiple sessions.

      SELECT 1
      FROM "MIDAS"."AQ$_(Queue Name)_QTAB_L"
      WHERE msgid = :1 AND subscriber# = :2 AND name = :3 AND address# = :4