首页 > 数据库技术 > 详细

[ORACLE] DB 表锁定问题

时间:2020-04-28 20:42:15      阅读:63      评论:0      收藏:0      [点我收藏+]

问题出现ORACLE表锁定

SQL> select object_name,session_id,os_user_name,oracle_username,process,locked_mode,status from v$locked_object l, all_objects a where l.object_id=a.object_id;

OBJECT_NAME          SESSION_ID OS_USER_NAME                   ORACLE_USERNAME                PROCESS                            LOCKED_MODE STATUS
-------------------- ---------- ------------------------------ ------------------------------ ---------------------------------- ----------- -------
TRD                      1453 orad4d                         SYS                            45613414                                     2 VALID
TRD                        79 d4dadm                         D4ddb                          46465810                                     3 VALID

锁定表session

SQL> select
(select username||:||sid||:||serial# from v$session where sid=a.sid) ||  阻塞了  ||
(select username ||:||sid||:||serial# from v$session where sid=b.sid)
from v$lock a,v$lock b
where a.block = 1 and b.request > 0 and a.id1 = b.id1 and a.id2 = b.id2;  2    3    4    5

(SELECTUSERNAME||:||SID||:||SERIAL#FROMV$SESSIONWHERESID=A.SID)||阻塞了||(SELECTUSERNAME||:||SID||:||SERIAL#FROMV$SESSIONWHERESID=B.SID)
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
D4ddb :79:21800 阻塞了 SYS:1453:19073

ORACLE 解决办法如下,SAP系统解决办法,取消相应的SAP程 (或取消对应的后台JOB)

select sid,serial# from v$session where osuser=D4ddb; 
alter system kill session ‘123,3935’;

 

[ORACLE] DB 表锁定问题

原文:https://www.cnblogs.com/tingxin/p/12796919.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!