My Oracle Support Banner

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 FEBRUARY 03, 2019

Applies to:

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


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"


To view full details, sign in with your My Oracle Support account.

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

In this Document

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