Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Forms 12c performance

GregorMFeb 10 2016 — edited Feb 14 2016

Hi.

We are in the middle of quality assurance test with Forms 12c. For the test we migrated application built on 10g version. Migration was done smoothly without any complications. With some tweaking (prestart and jvm settings) we noticed very quick startups and rendering requested forms.

Right now we are observing quite noticeable delays (compared to version 10g) when doing simple movement between rows in simple tabular form. I have tried everything it came to my mind to pinpoint the problem. Like tracing forms session, monitoring server and client jvm, created minimalistic form for comparison between 12c and 10g, tried from browser and web start with ohs and without. The results where :

- tracing forms session : shows "Duration" greater than 30 just on NETWORK.READ (between 720 and 1860) and NETWORK.WRITE event. Although I am not sure is this overall duration as the forms triggers are triggered in between network events or just the network  Btw anybody familiar with units the Duration is showed in.

- monitoring server and client jvm : on server side heap memory does not increase more than 800MB (max is 4GB). On client side heap memory does not increase more than 200MB. Cpu usage is under 2% on server and under 8% on client.

- browser with ohs and without ohs and web start : same behaviour regardless of client environment

What I have noticed is the "blue" forms indicator in the lower right corner has longer and frequent "trips" when on 12c than 10g. Dont know exactly but I think this indicator is "moving" when there is a communication between forms server and database on one and client jvm and forms server on the other hand. That in mind I started to think there could be some server or client jvm performance issue.

Has anybody noticed similar performance degradation or any idea what to check?

As for the configuration :

- server : forms 12c, jdk 1.8.0_65 64bit

- client : jre 1.7.0_71 32 bit

Br,

Gregor

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 13 2016
Added on Feb 10 2016
5 comments
1,624 views