Hi,
We are using Temenos R10 with Oracle 11g database. Our database usage becomes 100% during day end reporting operation, as a result overall system performance becomes very slow. Until we could increase database server resource, we would like to control load so that database don't reach 100% and overall system remains operational. Which parameters can we modify to control the amount of load generated by Temenos?
We checked that the queries run on reporting time, is well tuned. During transaction time, we don't face any performance problem.