UEL Performance Improvement
Last updated on DECEMBER 22, 2017
Applies to:Oracle Communications Billing and Revenue Management - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
***Checked for relevance on 24-APR-2015***
Universal Event Loader (UEL) performance is very slow. It is also observed that during processing, UEL executes below query which takes too much time (above 30 seconds).
batch_t.poid_rev, batch_t.created_t, batch_t.mod_t,
batch_t.descr, batch_t.end_t, batch_t.hostname, batch_t.pid,
batch_t.program_name, batch_t.start_t, batch_t.status
FROM batch_t, batch_gel_t
WHERE (batch_gel_t.input_file_name = :1 AND batch_t.poid_type = :2)
AND batch_t.poid_id0 = batch_gel_t.obj_id0
AND ((batch_t.poid_id0 >= :3 AND batch_t.poid_id0 < :4))
What causes UEL performance decrease ? How to improve UEL performance ?
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