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'; --最大进程数
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'; --最大进程数