My Oracle Support Banner

Improve I/O Preformance In Database when there are many rule jobs (Doc ID 1476945.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Communications Order and Service Management - Version 6.3.1 to 7.0.3 [Release 6.3 to 7.0.0]
Information in this document applies to any platform.


Is there a way to improve the DB I/O performance when the following command is consuming most of the system load?

DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN OSM_TRN.om_job_pkg.invoke_rule_engine(4,6,0,'D',2,2); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;


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.