Oracle查看链接数及最大链接数

# Oracle查看链接数及最大链接数
```
# 查看链接数
SQL> select count(*) from v$process;

COUNT(*)
----------
       348

# 查看并发链接数
SQL> select count(*) from v$session where status='ACTIVE';

COUNT(*)
----------
        54

# 查看用户使用的链接数
SQL> select username,count(username) from v$session where username is not null group by username;

USERNAME                       COUNT(USERNAME)
------------------------------ ---------------
USR_XG_RSFW                                 12
USR_MONITOR1                                 6
USR_RSFW                                    44
USR_ZZFW                                     8
USR_SUSTCREG                               128
USR_OANEW                                   91
HYBRID_ZZFW                                  6
SYS                                          2
USR_SUSTCWE                                  1

9 rows selected.

# 查看最大链接数等配置
SQL> show parameter processes

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     0
db_writer_processes                  integer     6
gcs_server_processes                 integer     3
global_txn_processes                 integer     1
job_queue_processes                  integer     1
log_archive_max_processes            integer     4
processes                            integer     1000

```