Query On OM_JMS_EVENT Table Is Taking a Long Time And Impacting The Performance Of The System
Last updated on DECEMBER 08, 2017
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"
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