High Growing Number Of FNDFS Processes Running FND_PROFILE.GET_SPECIFIC In Database

(Doc ID 1333299.1)

Last updated on MARCH 13, 2017

Applies to:

Oracle E-Business Suite Performance - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


Identified high number of FNDFS (LOCAL=NO) processes.

The following is the SQL part that it is calling:

declare dummy boolean;
fnd_profile.get_specific(:name, :use ...

Number of FNDFS processes are increasing in the Database, until Database goes down due to library cache lock.


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