2、SELECT sid, serial#, username, osuser FROM v$session where sid = 162; 将162换成你查出来的session_id 3、kill掉session ALTER SYSTEM KILL SESSION ‘162,4294‘; 4294为第二步查出来的serial#; 转自 http://www.cnblogs.com/yuxiaona/p/5862021.html解决ora-00054 Oracle锁表问题标签：本文系统来源：http://www.cnblogs.com/cmyxn/p/5906793.html
* from table for update当修改表中数据，但是没有commit就关掉PL/SQL，下次再打开执行上面sql语句，就会卡死，不能再for update 一、锁表 查看锁表进程SQL语句： select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID; 如果有记录，可查到如下锁表记录 二、解锁 杀掉锁表进程： 记录下SID和serial# ，分别替换掉下面的1155,39095，即可解除锁表alter system kill session ‘1155,39095‘; Or...
(1)锁表查询的代码有以下的形式：select count(*) from v$locked_object;select * from v$locked_object;(2)查看哪个表被锁select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id;(3)查看是哪个session引起的select b.username,b.sid,b.serial#,logon_time from v$locked_object a,v$session b where a.session_id = b.sid order by b.logon_time; (4)杀...
--以下几个为相关表SELECT * FROM v$lock;SELECT * FROM v$sqlarea;SELECT * FROM v$session;SELECT * FROM v$process ;SELECT * FROM v$locked_object;SELECT * FROM all_objects;SELECT * FROM v$session_wait; --查看被锁的表 select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id; --查看那个用户那个进程照成死锁select b.username,b.sid,b.seria...
1.用下列sql语句查询操作不当引起锁表的进程的SESSION_ID及USERNAME SELECT S.SID SESSION_ID, S.USERNAME, DECODE(LMODE, 0, ‘None’, 1, ‘Null’, 2, ‘Row-S (SS)’, 3, ‘Row-X (SX)’, 4, ‘Share’, 5, ‘S/Row-X (SSX)’, 6, ‘Exclusive’, TO_CHAR(LMODE)) MODE_HELD, DECODE(REQUEST, 0, ‘None’, 1, ‘Null’, 2, ‘Row-S (SS)’, 3, ‘Row-X (SX)’, 4, ‘Share’, 5, ‘S/Row-X (SSX)’, 6, ‘Exclusive’, TO_CHA...
count(*) from v$locked_object; select * from v$locked_object;(2)查看哪个表被锁select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id;(3)查看是哪个session引起的select b.username,b.sid,b.serial#,logon_time from v$locked_object a,v$session b where a.session_id = b.sid order by b.logon_time; (4)杀掉对应进程执行命令：alter system kil...
我遇到的情况： 当使用select语句查询表时，后面跟着for update ，select * from table for update当修改表中数据，但是没有commit就关掉PL/SQL，下次再打开，执行带for update的sql语句，就会卡死 一、锁表 查看锁表进程SQL语句： select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID; 如果有记录，可查到如下锁表记录 二、解锁 杀掉锁表进程： 记录下SID和serial# ，分别替换掉下面的1155,39...
--以下几个为相关表SELECT * FROM v$lock;SELECT * FROM v$sqlarea;SELECT * FROM v$session;SELECT * FROM v$process ;SELECT * FROM v$locked_object;SELECT * FROM all_objects;SELECT * FROM v$session_wait;--查看被锁的表select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id;--查看那个用户那个进程照成死锁select b.username,b.sid,b.seri...
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_timeFROM v$locked_object l, all_objects o, v$session sWHERE l.object_id = o.object_idAND l.session_id = s.sidand oracle_username = ‘用户名‘ --用户名要大写ORDER BY sid, s.serial# 2.解锁ALTER system KILL session ‘SID,serial#‘ Oracle查询锁表和解锁标签：system alter min ...
--锁表查询 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;?--释放SESSION SQL: --alter system kill session ‘sid, serial#‘; ALTER system kill session ‘23, 1647‘; -- ‘sid, serial#‘ oracle锁表问题标签：serial span alter size kill lock session oracle select 本文系统来源：...
通过for update锁表，通过操作系统方式和oracle方式终止进程方式 --查询需要终止进程的情况，包括操作系统进程 select proc.sPID, sess.sid, sess.serial#, lo.oracle_username, lo.os_user_name, ao.object_name, lo.locked_mode from v$locked_object lo, dba_objects ao, v$session sess,v$process proc where ao.object_id = lo.object_id and lo.session_id = sess.sid and sess.PA...
select value from v$parameter where name = ‘processes‘; --更改数据库连接数 alter system set processes = 3000 scope = spfile; --查看被锁的表 select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id; --查看当前活跃线程数 select s.status,s.* from v$session s where schemaname=‘数据库用户名‘ and machine=‘机器名‘; select sid,ser...
* FROM V$LOCK;SELECT * FROM V$SQLAREA;SELECT * FROM V$SESSION;SELECT * FROM V$PROCESS;SELECT * FROM V$LOCKED_OBJECT;SELECT * FROM ALL_OBJECTS;SELECT * FROM V$SESSION_WAIT;2、查看被锁的表SELECT B.OWNER, B.OBJECT_NAME, A.SESSION_ID, A.LOCKED_MODEFROM V$LOCKED_OBJECT A, DBA_OBJECTS BWHERE B.OBJECT_ID = A.OBJECT_ID;3、查看那个用户那个进程照成死锁SELECT B.USERNAME, B.SID, B.SERIAL#, LOGON_TIMEFROM V$LO...
1.开一个会话session1SQL>select sid from v$mystat where rownum=1;SID158SQL>create table t(x int primary key);table createdSQL>insert into t values(1);commit;SQL>update t1 set t=10 where x=1;2.再开一个会话SQL>select sid from v$mystat where rowunm=1;SID157SQL>update t1 se x=10 where x=1;这个时候session2被session1锁住3、执行以下语句查看是哪个进程和序列锁住了表select sess.sid, sess.serial#, ...
//查询那些对象被锁 select object_name,machine,s.sid,s.serial#from v$locked_object l,dba_objects o ,v$session swhere l.object_id = o.object_id and l.session_id=s.sid; //杀死进程 alter system kill session ‘sid,serial#‘;oracle锁表，解锁标签：alter oracle锁表 ssi session machine _id HERE alt sele 本文系统来源：https://www.cnblogs.com/lijianan/p/10172437.html