q_kill_sess_dml sql拼接杀会话语句

admin

1. select 'alter system kill session ''' || sid || ',' || serial# || ''';'
   
2.   from v$session
   
3. where sid in
   
4.        (select sid from v$session where sql_id='3d8tczpt1v7vj' or sql_id='ajvc4f9ccyzbx')
   
5. /
   
6. 
   
7. select 'alter system kill session ''' || sid || ',' || serial# || ''';'
   
8.   from v$session
   
9. where sid in
   
10.        (select sid from v$session where  event='direct path read' and username='SCYW')
    
11. /
    
12. 
    
13. select spid from v$process
    
14. where addr in
    
15.        (select paddr from v$session where username='ODS_DD_PDWYXJC')
    
16. /
    
17. 
    
18. select 'alter system kill session ''' || sid || ',' || serial# || ''';'
    
19.   from v$session
    
20. where username='MCTP';
    
21. 
    
22. set pagesize 2000
    
23. SELECT '! kill -9 '||p.spid FROM v$session  s INNER JOIN v$process  p ON (s.paddr = p.addr) WHERE s.username ='MCTP' and s.status='INACTIVE';
    

复制代码