oracle杀掉连接

时间:2023-02-15 09:10:58

相关sql

--查看当前连接
select count(*) from v$process --数据库允许的最大连接数
select value from v$parameter where name = 'processes' --查看连接用户
SELECT osuser, a.username,cpu_time/executions/||'s', sql_fulltext,machine
from v$session a, v$sqlarea b
where a.sql_address =b.address order by cpu_time/executions desc; --生成杀掉python连接的语句,只标为killed
select 'alter system kill session '''||sid||','||serial#||''';' from v$session where module like '%python%';

将连接状态标为killed

alter system kill session '10,25389'

oracle杀掉连接

立刻杀掉连接

alter system kill session '10,25389' IMMEDIATE;

plsql查看连接

tool -> sessions

oracle杀掉连接

oracle以管理员登陆

用户名:username

密码:password as sysdba