While Receiving Messages Through MQ Receiver Component, Log Shows Millions of Hits On S_WORKSPACE Table (Doc ID 2915585.1)

Last updated on FEBRUARY 24, 2023

Applies to:

Symptoms

The issue can be reproduced at will with the following steps:

1. Use How To Configure Siebel EAI JMS Transport Integration With Apache ActiveMQ (Doc ID 1404673.2) to configure JMS integration with ActiveMQ and use any workflow to process the message.

2. Make sure that MQ receiver component is up and running. Observed that there is significant increase in CPU usage. 

While reviewing MQ receiver component logs found that for every call of Business Service 'EAI JMS Transport', one SQL query on S_WORKSPACE was triggered.

At Connection Subsystem level parameter "MqSleepTime" was set to 50 which means 50ms. Hence MQ receiver waits 50ms to get a message, if queue stays empty, it loops and therefore run this SQL

query against S_WORKSPACE for every 50ms.

Cause

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