Oracle Forms Performance Tuning

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.

Comments:

Dear Grant, Can you please answer this simple question.
Question: A user of your Forms 10g Telco application complaints that his form is slow. What should you do in order to find where the problem is and give a solution? Is there a "Oracle Recommended" procedure or is it one a case-by-case basis? What is the most common cause of a "slow form"? Is it a slow running query? or some other problem? If it is a slow-running query how can you pinpoint the query?
Thanks in advance
Rohan

Posted by guest on August 12, 2013 at 03:10 PM BST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Tips, Tricks, Events and Information around Oracle JDeveloper, ADF, and Oracle Forms

Search

Archives
« July 2014
MonTueWedThuFriSatSun
 
2
3
4
5
6
8
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
   
       
Today