oracle kill 锁

最新推荐文章于 2024-03-22 10:19:50 发布

weixin_30843605

最新推荐文章于 2024-03-22 10:19:50 发布

阅读量85

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/ss-33/p/8601695.html

版权

select object_name as 对象名称,s.sid,s.serial#,p.spid as 系统进程号 from v$locked_object l , dba_objects o , v$session s , v$process p where l.object_id=o.object_id and l.session_id=s.sid and s.paddr=p.addr;

alter system kill session '1039,21219';

select sid,serial#,username,SCHEMANAME,osuser,MACHINE,s.sql_id terminal,PROGRAM,owner,object_name,object_type,o.object_id from dba_objects o,v$locked_object l,v$session s where o.object_id=l.object_id and s.sid=l.session_id;

转载于:https://www.cnblogs.com/ss-33/p/8601695.html