select count(*) from v$session; --查看当前连接进程数,包含后台进程
select count(distinct username) from v$session; --查看连接的用户个数如果把某些连接下线,即杀死其进程,要在v$session中找到sid和serial#
然后执行一下语句:
alter system kill session 'sid, serial#';
select count(distinct username) from v$session; --查看连接的用户个数如果把某些连接下线,即杀死其进程,要在v$session中找到sid和serial#
然后执行一下语句:
alter system kill session 'sid, serial#';
alter system kill session 'sid,serial#';