CPU Consumption Of Queue Monitor Processes Increases when using Retention (Doc ID 343282.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Symptoms

Queue Monitor process consuming large amounts of CPU and inefficiently removing processed messages
when high message volumes and retention are used in a single-consumer queue table.

Generating 10046, level 12 tracing for the relevant queue monitor process shows that the most inefficient and resource consuming sql statement is of the form

select min(time_manager_info) from <USER.QUEUE_TABLE_NAME> where state not in  (:2, :3)
 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.