单机 ora-60

模拟：

create table emp (no int,sal number);
insert into emp values(1,100);
insert into emp values(2,300);
commit;

会话1：
update emp set sal=sal+100 where no=1;
会话2：
update emp set sal=sal+200 where no=2;

然后会话1：
update emp set sal=sal+1 where no=2;
等执行完会话2的sql几秒后，报死锁 ORA-00060

会话2：
update emp set sal=sal-2 where no=1;
挂起

告警日志

2022-08-29 09:11:28.720000 -07:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_5271.trc:
ORA-00060: Deadlock detected. See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors.
More info in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_5271.trc.

trc部分内容：

2022-08-29 09:11:28.712*:ksq.c@13169:ksqdld_hdr_dump():
DEADLOCK DETECTED ( ORA-00060 )
See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors

[Transaction Deadlock]

The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:

Deadlock graph:
------------Blocker(s)-----------  ------------Waiter(s)------------
Resource Name                             process session holds waits serial  process session holds waits serial
TX-00060000-000008D0-00000000-00000000         51 268  X        61619      37 277  X  49963
TX-000A0018-00000739-00000000-00000000         37 277  X        49963      51 268  X  61619

----- Information for waiting sessions -----
Session 268:
sid: 268 ser: 61619 audsid: 4294967295 user: 0/SYS
flags: (0x8000041) USR/- flags2: (0x40009) -/-/INC
flags_idl: (0x1) status: BSY/-/-/- kill: -/-/-/-
pid: 51 O/S info: user: oracle, term: UNKNOWN, ospid: 5271
image: oracle@bjdb (TNS V1-V3)
client details:
O/S info: user: oracle, term: pts/2, ospid: 5270
machine: bjdb program: sqlplus@bjdb (TNS V1-V3)
application name: sqlplus@bjdb (TNS V1-V3), hash value=3524224488
current SQL:
update emp set sal=sal+1 where no=2

Session 277:
sid: 277 ser: 49963 audsid: 4294967295 user: 0/SYS
flags: (0x41) USR/- flags2: (0x40009) -/-/INC
flags_idl: (0x1) status: BSY/-/-/- kill: -/-/-/-
pid: 37 O/S info: user: oracle, term: UNKNOWN, ospid: 7328
image: oracle@bjdb (TNS V1-V3)
client details:
O/S info: user: oracle, term: pts/1, ospid: 7327
machine: bjdb program: sqlplus@bjdb (TNS V1-V3)
application name: sqlplus@bjdb (TNS V1-V3), hash value=3524224488
current SQL:
update emp set sal=sal-2 where no=1

----- End of information for waiting sessions -----