Basic Perfomance Tuning For stuck threads and response times

Documentation for performance tuning:

https://docs.oracle.com/en/middleware/fusion-middleware/12.2.1.4/asper/redundant-cross-references-removal.html#GUID-72599446-A5C9-48B8-AA2F-6A330396E4E1

For stuck threads and response times, specifically look into the following:
1. Tuning JVM Memory Settings for Oracle Identity Governance
2. Tuning the JDBC Connection Pool for Oracle Identity Governance
3. Tuning OIG-specific Work Manager Properties
4. JMS tuning

The Response on Process Task isn't getting deleted

The Response on Process Task isn't getting deleted as the response is used by one or more tasks

 

To delete the response we need to find the process tasks triggered with same response 

 

select MIL_KEY from MIL where MIL_NAME='';

find the response which need to delete

select * from RSC where MIL_KEY ='1084'; 

find the process tasks triggered uses this response code

select * from OSI where  RSC_KEY='' and MIL_KEY =''; 

delete the process tasks which uses this response code.

delete from OSI  where  RSC_KEY='' and MIL_KEY ='';

Now login to design console

and delete the response you wanted to delete