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