Improve I/O Preformance In Database when there are many rule jobs

(Doc ID 1476945.1)

Last updated on SEPTEMBER 18, 2017

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.

Goal

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;
 

Solution

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