UEL Performance Improvement

(Doc ID 844480.1)

Last updated on DECEMBER 22, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 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).

SELECT DISTINCT batch_t.poid_db, batch_t.poid_id0, batch_t.poid_type,
batch_t.poid_rev, batch_t.created_t, batch_t.mod_t,
batch_t.read_access, batch_t.write_access,
batch_t.account_obj_db, batch_t.account_obj_id0,
batch_t.account_obj_type, batch_t.account_obj_rev,
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