数据线程监控

select count(*) from v$process;

Select count(*) from v$session;

select count(*) from v$session where status='ACTIVE';

select sid,serial#,username,program,machine,status from v$session;

select value from v$parameter where name = 'processes'; --最大进程数