ORA-00020错误

ORA-00020错误
问题描述：测试组的Oracle数据库老是挂掉，于是乎检查了一下oracle的alert日志，具体错误信息如下：
Tue Oct 15 18:55:12 2013
ORA-00020: maximum number of processes 150 exceeded
ORA-20 errors will not be written to the alert log for
 the next minute. Please look at trace files to see all
 the ORA-20 errors.
Tue Oct 15 18:55:44 2013
Process W000 submission failed with error = 20
Process W000 submission failed with error = 20
Process W000 submission failed with error = 20
Process W000 submission failed with error = 20
数据库的进程数太小了，解决方法如下：
SQL> show parameter processes;


NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     0
db_writer_processes                  integer     1
gcs_server_processes                 integer     0
global_txn_processes                 integer     1
job_queue_processes                  integer     1000
log_archive_max_processes            integer     4
processes                            integer     150
SQL> alter system set session=1000 scope=spfile;
system alteted
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.


Total System Global Area 1720328192 bytes
Fixed Size                  2176448 bytes
Variable Size            1325402688 bytes
Database Buffers          385875968 bytes
Redo Buffers                6873088 bytes
Database mounted.
Database opened.
SQL> show parameter processes;


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

知识扩展：

查询oracle alert日志文件的位置：

SQL〉select * from v$diag_info where name='Diag Alert';

查看Oracle最大进程数：
SQL> select count(*) from v$session  #连接数
SQL> Select count(*) from v$session where status='ACTIVE'　#并发连接数
SQL> show parameter processes  #最大连接
SQL> alter system set processes = value scope = spfile;重启数据库  #修改连接


unix 1个用户session 对应一个操作系统 process 
而 windows体现在线程


------------------------------------------------------------------------------