Improve I/O Preformance In Database when there are many rule jobs
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.
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;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms