Oracle Forms Performance Tuning
By Grant Ronald on Apr 11, 2011
A question that I get asked, probably on a weekly basis, is whether I have any tips and techniques for tuning the performance of an Oracle Forms application. I’ve been meaning to write a blog about this for ages but then I saw the guys at Amis had published something which hits most of the points.
The one lesson I have learned is that you can very quickly eliminate great chunks of your application using the following:
1) Test a simple form with no database connection and 3 or 4 fields. This quickly establishes a “latency” test to see if you can get acceptable performance when tabbing between fields
2) Also run a simple emp/dept form – again check that you get the performance you expect when pulling back a couple of hundred EMP/DEPT records
I’m sometimes amazed that these simple baseline tests are missed out which means you can’t be certain its not your code or your database tuning that’s at the heart of the issues.
The other point is that 10s (probably 100s) of thousands of Forms applications are in production. Forms can perform well on a network (sometimes better than client/server!) – the main things to watch out for are bad coding practice or high latency…and these tips should help you get to the bottom of those questions pretty quickly.