Poor Performance of Some Forms after Database Upgrade from 11.2 to12c - Queries Against ALL_SYNONYMS Are Slower
(Doc ID 2304324.1)
Last updated on APRIL 19, 2023
Applies to:
Oracle Forms - Version 11.1.2.1.0 and laterOracle Forms for OCI - Version 12.2.1.4.0 and later
Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.
Symptoms
After upgrading the database from 11.2 to 12c, internal Forms queries against the ALL_SYNONYMS views in the database are much slower than with the 11.2 database.
These ALL_SYNONYMS views are within the Forms internal code and are not a part of the application.
In the database SQL trace, the following query is seen:
SELECT OBJ.OBJECT_TYPE, OBJ.OBJECT_NAME, OBJ.OWNER
INTO :b0, :b1, :b2
FROM ALL_SYNONYMS SYN, ALL_OBJECTS OBJ
WHERE ( ( ( (SYN.SYNONYM_NAME = :b1 AND SYN.OWNER = :b2)
AND SYN.TABLE_NAME = OBJ.OBJECT_NAME)
AND SYN.TABLE_OWNER = OBJ.OWNER)
AND OBJ.OBJECT_TYPE IN ('TABLE', 'VIEW', 'SYNONYM'))
SELECT RTRIM (SYS_CONTEXT ('userenv', 'current_schema')) FROM DUAL
This statement is seen many times within the Forms session for certain forms / .fmxs.
What is causing this behavior?
Changes
Upgraded the database from 11g to 12c.
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 |