I have a parent table and a child table, the child table foreign keys the parent table primary keys, cascading delete, and a trigger to delete the parent table data while deleting the child table data, but now there is an error. deadlock,my trigger simply deletes the associated parent table data
This trigger has two deletions, I only deactivate the second foreign key to delete, the foreign key also has an index, but there are many other foreign keys in production, it can be deleted before, recently exploded this error

Error Msg = ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "C##SHUDIANADMIN.AREA_TB_DELETE", line 6
ORA-04088: error during execution of trigger 'C##SHUDIANADMIN.AREA_TB_DELETE
        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
        ... 173 more