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