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 JUNE 07, 2021

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.


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.




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

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