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.
FROM "MIDAS"."AQ$_(Queue Name)_QTAB_L"
WHERE msgid = :1 AND subscriber# = :2 AND name = :3 AND address# = :4