当前位置：网站首页>Oracle kills the executing SQL

Oracle kills the executing SQL

2022-04-23 13:40:00 【Wangcai 2】

  Find out what is being implemented sql

SELECT b.sid oracleID,
b.username  Sign in Oracle user name ,
b.serial#,
spid  operating system ID,
paddr,
sql_text  Ongoing SQL,
b.machine  Computer name 
FROM   v$session b
left join  v$process a on a.addr = b.paddr
left join  v$sqlarea c on b.sql_hash_value = c.hash_value

How to write Kill the process sql 

alter system kill session '{ORACLEID},{SERIAL#}';    as follows :

 

alter system kill session '1345,20312';
alter system kill session '4,21443';
alter system kill session '1342,35376';

版权声明
本文为[Wangcai 2]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230604301745.html

边栏推荐

猜你喜欢

随机推荐