My Oracle Support Banner

Query Running In Background And Taking HIGH CPU Utilization On Production Instance (Doc ID 2579215.1)

Last updated on AUGUST 21, 2019

Applies to:

Oracle Concurrent Processing - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Goal

Following query running continuously  in prod instance  which is taking HIGH CPU Utilization.
Please provide us solution of it.

Select R.Rowid
  From Fnd_Concurrent_Requests R
 Where R.Hold_Flag = 'N' And R.Status_Code = 'I' And
  R.Requested_Start_Date <= Sysdate And
  (R.Node_Name1 is null or
  (R.Node_Name1 is not null and
  FND_DCP.target_node_mgr_chk(R.request_id) = 1)) AND EXISTS
 (Select Null
  From Fnd_Concurrent_Programs P
  Where P.Enabled_Flag = 'Y' And
  R.Program_Application_Id = P.Application_Id And
  R.Concurrent_Program_Id = P.Concurrent_Program_Id AND EXISTS
  (Select Null
  From Fnd_Oracle_Userid O
  Where R.Oracle_Id = O.Oracle_Id AND EXISTS
  (Select Null
  From Fnd_Conflicts_Domain C
  Where P.Run_Alone_Flag = C.RunAlone_Flag And
  R.CD_Id = C.CD_Id)) And
  (P.Execution_Method_Code != 'S' OR
  (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN
   AND
  ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) NOT IN
  ORDER BY NVL(R.priority, 999999999), R.Priority_Request_ID, R.Request_ID
 

Solution

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
Goal
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.