My Oracle Support Banner

Forms 11g and Forms 10gR2: Queries and Compilations against an 11g Database are Slow or Sometimes Hang (Doc ID 880660.1)

Last updated on SEPTEMBER 20, 2019

Applies to:

Oracle Forms - Version 10.1.2 and later
Information in this document applies to any platform.
***Checked for relevance on 13-Feb-2013***
Checked for relevance on 29-Jun-2015

Symptoms

Using Forms 11g or 10gR2 against an 11g DB and the performance is poor when:

a.  Querying against the DB.

b.   When trying to compile form against an 11g Database using 'frmcmp.sh' and 'frmcmp_batch.sh' compilers, it may hang or it take a long (10 min +)
Compile command is like:
frmcmp_batch.sh module=test.fmb module_type=FORM compile_all=YES userid=username/password@DB

There are no problems with queries or compilation with the same Form(s) against 10g database versions.

Changes

 Upgraded from 10g to 11g DB

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.