本文探讨了如何使用SQL语句查询特定用户的会话及其锁定的对象，并通过实例展示了使用ALTER SYSTEM命令立即结束指定会话的方法。
select * from v$session a ,v$locked_object b ,dba_objects c
where a.sid = b.session_id
and b.object_id = c.object_id
and a.username = 'NOVA'
alter system kill session '152,41451' immediate;
where a.sid = b.session_id
and b.object_id = c.object_id
and a.username = 'NOVA'
alter system kill session '152,41451' immediate;
扫一扫
2514
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
