Oracle查看和修改连接数

zhouwei1990

select count(*) from v$process ;  表示数据库进程数
select count(*) from v$session ;表示数据库当前会话数
select count(*) from v$sessionwhere status='ACTIVE';
SQL> selectosuser,a.username,cpu_time/executions/1000000||'s',sql_fulltext,machine
2  from v$session a,v$sqlarea b
3  where a.sql_address = b.address
4  order by cpu_time/executionsdesc;表示当前正在执行的SQL信息及会话情况