My Oracle Support Banner

Concurrent Managers are consuming high CPU and memory (Doc ID 1075684.1)

Last updated on MAY 11, 2020

Applies to:

Oracle E-Business Suite Performance - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Concurrent Processing - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Oracle Application Object Library - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Overall database performance degrades and FNDLIBR processes consumes high CPU and memory on the server.

AWR reports point to following SQLs with very high execution counts :


Manager log files are also flooded with the following messages:

Cause: UPDATE_STATUS failed due to ORA-01002: fetch out of sequence.

The SQL statement being executed at the time of the error was: update
fnd_concurrent_requests set phase_code = :phase ,status_code = :status,
completion_text = :text where request_id = :reqid and was executed from the
file &ERRFILE.  User XXX or Responsibility YYYY has expired. Cannot
process request XXXX. APP-FND-01564: ORACLE error 1002 in UPDATE_STATUS

This problem usually affects 11G database users. But problem is also reported against 9i and 10G databases.

Changes

Upgraded database to 11G .

End dated a user or a responsibility of a user, but there is a scheduled request.

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.