SQL> select count(*) from v$session #當前的連線數SQL> Select count(*) from v$session where status=‘ACTIVE’ #併發連線數SQL> select value from v$parameter where name = ‘processes’ ——資料庫允許的最大連線數SQL> show parameter processes #最大連線 SQL> select username,count(username) from v$session where username is not null group by username; #檢視不同使用者的連線數希望能幫到你