My Oracle Support Banner

12.2 E-Business Suite Performance System Tuning AWR Reports Show Increased Executions Of fnd_global.apps_initialize And Latch Free Wait Events After Increased The result_cache_max_size Parameter (Doc ID 2538442.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Application Object Library - Version 12.2.6 to 12.2.7 [Release 12.2]
Oracle E-Business Suite Performance - Version 12.2 to 12.2.7 [Release 12.2]
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.2 Performance, System Tuning related issues

 

 

 

 

During user benchmark runs the AWR reports show an increased number of executions for fnd_global.apps_initialize.

These latch free wait events occur even after increasing the result_cache_max_size parameter.

The AWR reports identify the executions OF FND_GLOBAL.APPS_INITIALIZE query each time getJDBCConnection is called.

Changes

 

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.