读取oracle页面或者进程卡住不动(死锁)

* from v$session where sid in (select session_id from v$locked_object) SELECT s.username,l.OBJECT_ID,l.SESSION_ID,s.SERIAL#,l.ORACLE_USERNAME,l.OS_USER_NAME,l.PROCESS FROM V$LOCKED_OBJECT l,V$SESSION S WHERE l.SESSION_ID=S.SID; 　alter system kill session ‘63,30893‘;

 

读取oracle页面或者进程卡住不动(死锁)

标签：

本文系统来源：http://www.cnblogs.com/liupengfei19940119/p/4565208.html

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！