select value from v$parameter where name = ‘processes’ —最大连接数 1024
Select from v$open_cursor Where user_name=’sxpj ‘—游标数量
select value from v$parameter where name = ‘open_cursors’—最大游标数 300
select count() from v$session—oracle连接数 65
select count(*) from v$session where status=’ACTIVE’—查询oracle的并发连接数 23