oracle进程数查询

1.cmd
2.sqlplus /nolog
3.connect sys/test@test as sysdba

SQL> show parameter process;

NAME                                 TYPE        VALUE
------------------------------------ ----------- -----
aq_tm_processes                      integer     0
db_writer_processes                  integer     1
gcs_server_processes                 integer     0
job_queue_processes                  integer     10
log_archive_max_processes            integer     2
processes                            integer     1000



再查进程数

SQL> select count(*) from v$session;

  COUNT(*)
----------
       224