oracle Kill 用户进程示例

最新推荐文章于 2025-10-11 15:21:03 发布

原创最新推荐文章于 2025-10-11 15:21:03 发布 · 268 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

数据库专栏收录该内容

13 篇文章

订阅专栏

本文介绍如何使用SQL查询来查找Oracle数据库中特定用户的活跃会话，并提供终止这些会话的方法。此外，还展示了如何找出被锁定的对象及其相关信息。

[b]查看用户会话[/b]：


select t2.SPID, t1.sid, t1.username, t1.status,t1.LOGON_TIME
from v$session t1
join v$process t2 on t1.PADDR = t2.ADDR
where t1.username = 'ETL'
 and t1.status = 'ACTIVE'
 and t1.LOGON_TIME < sysdate -1

[b]命令行orakill命令[/b]（ORCL即$ORACLE_SID）：


select  'orakill  ORCL '|| t2.spid as command
from v$session t1
join v$process t2 on t1.PADDR = t2.ADDR
where t1.username = 'ETL'
 and t1.status = 'ACTIVE'
 and t1.LOGON_TIME < sysdate -1

[b]命令行orakill命令（针对锁进程）[/b]


SELECT 
  o.OWNER
 ,o.OBJECT_NAME
 ,l.SESSION_ID
 ,s.SERIAL# 
 ,s.LOGON_TIME
 ,p.SPID
 ,'orakill ORCL '||p.SPID as command
FROM v$locked_object l
join all_objects o on l.OBJECT_ID=o.OBJECT_ID
join v$session s on l.SESSION_ID=s.SID
join v$process p on s.PADDR = p.ADDR