ORA-01436: CONNECT BY loop in user data

1)  Error in Logs: java.sql.SQLException: ORA-01436: CONNECT BY loop in user data

Run the following query to check the cycle:

select parent_key, act_key, level, connect_by_iscycle
from act
connect by NOCYCLE prior act_key=parent_key;

In case that PARENT_KEY is equal with the ACT_KEY of an organization, that data should be corrected.

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