Oracle synonym Source Library lock table causes target Library delete operation report Ora 02055 02049 02063 06512

Symptom: 02055 02049 02063 06512 error reported in Target library during stored procedure

Troubleshooting process:
1. Querying the 110 rows of the stored procedure is just a simple delete action

2, through the following SQL statement to find the deadlock, no deadlock
SELECT ' alter system kill session ' | | Chr (39) | | l.session_id| | ', ' | | s.serial#| | Chr (39) | | immediate; ', l.session_id sid,s.serial#,l.locked_mode,l.oracle_username,l.os_user_name,
S.machine,s.terminal,o.object_name,s.logon_time
From V$locked_object L, all_objects O, v$session s
WHERE l.object_id = o.object_id and l.session_id = S.sid
ORDER by Sid, S.serial#;

3, RAC another node, the same statement above also did not see a deadlock
4, immediately think of whether it is a synonym synonyms, by the following statement query is indeed a synonym

5, and then query the relevant db_link, find the synonym related table library
6, go to the library with the statement of Step two to detect the deadlock
7. Kill the Lock
Sql> alter system kill session ' 2015,55997 ' immediate;

System altered.
9. The stored procedure for executing the target library is back to normal.

Oracle synonym Source Library lock table causes target Library delete operation report Ora 02055 02049 02063 06512