Initial Information to Collect to Start Diagnosis of Oracle Forms "Slowness" Issue (Slow Navigation / Latency / ..)

(Doc ID 1902638.1)

Last updated on JUNE 26, 2017

Applies to:

Oracle Forms - Version 11.1.1.1.0 and later
Information in this document applies to any platform.
Checked for relevance on 01-Feb-2016

Goal

An "Oracle Forms" Application "involves" many components :

 - A Forms Applet running in a Java Plugin running in a Browser
 - A HTTP Server with a module mod_wl_ohs receiving the requests from the Java Plugin and forwarding these requests to WLS_FORMS
 - A Forms listener servlet running in WLS_FORMS receiving the requests and forwarding them to the forms runtime
 - A Forms Runtime (frmweb) executing the PL/SQL code
 - A Database

The goal of this document is to describe what "timing" information can be collected in order to find out which component(s) may be responsible for the "slowness".

The information collected by this article is vital in starting the analysis of the "slowness" situations. But finding the root cause of each specific case has its own dynamics.
So it is important to understand that it is not possible to detect the root cause of any situation only with the information collected by this article or only with some specific method.
The next step of analysis would be determined by the analysis of information collected in this article.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms