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 JANUARY 23, 2024
Applies to:
Oracle Communications Order and Service Management - Version 7.2.2 and laterInformation 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"
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |