Improve I/O Preformance In Database when there are many rule jobs
(Doc ID 1476945.1)
Last updated on MARCH 29, 2023
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
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
| Goal |
| Solution |
| References |