--查看当前连接

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%';