相关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'
立刻杀掉连接
alter system kill session '10,25389' IMMEDIATE;
plsql查看连接
tool -> sessions
oracle以管理员登陆
用户名:username
密码:password as sysdba