接口带不动,超时,取消报文发送,导致锁表
搜索到以下解决方法
先查出锁定的表,
执行最后一列 FREESQL 处理锁定的表
SELECT SESS.SID,
SESS.SERIAL#,
LO.ORACLE_USERNAME,
LO.OS_USER_NAME,
AO.OBJECT_NAME 被锁对象名,
LO.LOCKED_MODE 锁模式,
sess.LOGON_TIME 登录数据库时间,
‘ALTER SYSTEM KILL SESSION ‘’’ || SESS.SID || ‘,’||SESS.SERIAL#||‘’‘’ FREESQL
FROM V
L
O
C
K
E
D
O
B
J
E
C
T
L
O
,
D
B
A
O
B
J
E
C
T
S
A
O
,
V
LOCKED_OBJECT LO, DBA_OBJECTS AO, V
LOCKEDOBJECTLO,DBAOBJECTSAO,VSESSION SESS
WHERE AO.OBJECT_ID = LO.OBJECT_ID
AND LO.SESSION_ID = SESS.SID
ORDER BY sid, sess.serial#;
没有权限执行下面这一句
grant alter system to name;/数据库名/