oracle forms and reports server 11gr2 (11.1.2.2.0) is slow while process plsql code in form
Hi Everyone,
I have 2 forms and reports server which is following
- oracle forms and reports server 11gr1 on (weblogic 10.3.5.0)
- oracle forms and reports server 11gr2 (11.1.2.2.0) on (weblogic 10.3.6.0)
Both server are connected with same database and running on same environment oracle linux 6 (64 bit), right now I am facing a issue that my new server (11gr2) is slower than old one (11gr1) while updating data in database, basically it call a PROCEDURE inside the form.
Time difference between those server are following
Record count | Time for server 11gr2 (mm:ss.1/100s) | Time for server 11gr1 (mm:ss.1/100s) | Note |
---|---|---|---|
400 | 01.40.75 | 00:.39.65 | database and forms are same |