[Oracle技能]锁表临时处理
发布时间：2020-12-12 13:35:53 所属栏目：百科 来源：网络整理
导读：第一步：找出被锁的表及相关信息 SELECT object_name,machine,s.sid,s.serial# FROM gv$locked_object l,dba_objects o,gv$session s WHERE l.object_id= o.object_id AND l.session_id = s.sid; ? OBJECT_NAME?? ??? ??? ??? ??? ??? ???? ??? ? MACHINE??
|
第一步：找出被锁的表及相关信息 SELECT object_name,machine,s.sid,s.serial# FROM gv$locked_object l,dba_objects o,gv$session s WHERE l.object_id= o.object_id AND l.session_id = s.sid; ? OBJECT_NAME?? ??? ??? ??? ??? ??? ???? ??? ? MACHINE?? ??? ??? ??? ??? ??? ?? SID??? SERIAL#------------------------------------------------------------ ----------------------------------- ------- ------------ TEAM_CHECK_ORDER_SPLIT ?? ??? ??? ??? ??? ?z-PC?? ??? ??? ??? ??? ??? ??? ??? ????? 600?? ? 25 TEAM_CHECK_ORDER_SPLIT ?? ??? ??? ??? ??? ?z-PC?? ??? ??? ??? ??? ??? ??? ??? ?????? 20???? 2865 TEAM_CHECK_ORDER_SPLIT ?? ??? ??? ??? ??? ?z-PC?? ??? ??? ??? ??? ??? ??? ??? ?????? 32?? ? 19 TEAM_CHECK_ORDER_SPLIT ?? ??? ??? ??? ??? ?z-PC?? ??? ??? ??? ??? ??? ??? ??? ????? 598?? ?193 TEAM_CHECK_SETTLEMENT_DETAIL?? ??? ?z-PC?? ??? ??? ??? ??? ??? ??? ??? ????? 600?? ? 25 TEAM_CHECK_SETTLEMENT_DETAIL?? ??? ?z-PC?? ??? ??? ??? ??? ??? ??? ??? ?????? 32?? ? 19 TEAM_CHECK_SETTLEMENT_DETAIL?? ??? ?z-PC?? ??? ??? ??? ??? ??? ??? ??? ????? 598?? ?193 ? 第二步：清理会话 alter system kill session ‘sid,serial#‘; ? > ALTER system kill session ‘600,25‘; System altered. > ALTER system kill session ‘20,2865‘; System altered. > ALTER system kill session ‘32,19‘; System altered. > ALTER system kill session ‘598,193‘; System altered. ? 再次查询： no rows selected （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |