Last updated on JANUARY 02, 2015
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 9.0.1 to 11.1]
Information in this document applies to any platform.
How the problem may manifest itself will depend on the amount of Advanced Queueing (AQ) activity in the database and on the configuration of the Queues.
The symptoms may include but are not limited to the following:
1. It may be observed as a space management issue in that the segment associated with the dequeue IOT/index, AQ$_< QUEUE_TABLE_NAME >_I, gradually grows in size. (AQ$_ < QUEUE_TABLE_NAME >_I will be an IOT for a Multi consumer queue table and an index for a Single consumer queue table.)
2. Dequeue performance may be seen to degrade over time due to the increasing size of the segment associated with the IOT/index.
3. In 10850 level 2 queue monitor tracing entries of the form kwqitremb: Skipping <OWNER>.AQ$_ <QUEUE_TABLE_NAME > _I will be recorded.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms