Query On OM_JMS_EVENT Table Is Taking a Long Time And Impacting The Performance Of The System (Doc ID 1914427.1)

Last updated on DECEMBER 04, 2015

Applies to:

Oracle Communications Order and Service Management - Version 7.2.2 and later
Information in this document applies to any platform.

Symptoms

There is a query on OM_JMS_EVENT table which is running repeatedly and causing system performance issues.

The SQL captured from AWR report for this is as follows:
select * from om_jms_event where status is null and ((om_handler_pkg.order_id_hash(order_seq_id, :1 ) between :2 and :3 ) or (order_seq_id member of :4 )) order by order_seq_id for update wait :"SYS_B_0"

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms