Oracle session scripts

来源：互联网发布：php get数据编辑：程序博客网时间：2024/06/05 18:15

select s.USERNAME,s.STATUS,s.machine, s.SERVER,s.PROGRAM from v$session s,v$process p
where s.paddr=p.addr and s.username='FXCP';

select s.USERNAME,s.STATUS,s.sid, s.serial#, p.spid from v$session s,v$process p
where s.paddr=p.addr and s.username='FXCP';

select s.USERNAME,s.STATUS,s.machine, s.SERVER,s.PROGRAM from v$session s,v$process p
where s.paddr=p.addr and p.spid in ('230928','254170','123320');

select s.sid,s.serial#,s.machine,p.spid,s.status from v$session s,v$process p where s.paddr=p.addr and s.sid='156';

select 'alter system kill session '''||s.sid||','||s.serial#||''';' from v$session s,v$process p where s.paddr=p.addr and s.sid='156';

select 'alter system kill session '''||s.sid||','||s.serial#||''';' from v$session s,v$process p where s.paddr=p.addr and s.username='FXCP';

select 'alter system kill session '''||s.sid||','||s.serial#||''';'||spid from v$session s,v$process p
where s.paddr=p.addr and s.sid = 312

select * from v$process p where not exists (select * from v$session s where p.addr=s.paddr) and p.pid <> 1;

alter system kill session '150,69';
alter system kill session '142,269';

0 0