ORA-00020连接数满处理方式

1、查看数据库当前连接数

SQL> show parameter process;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     1
cell_offload_processing              boolean     TRUE
db_writer_processes                  integer     10
gcs_server_processes                 integer     4
global_txn_processes                 integer     1
job_queue_processes                  integer     1000
log_archive_max_processes            integer     4
processes                            integer     4500
processor_group_name                 string

SQL> select inst_id,count(*) from gv$session group by inst_id;

   INST_ID   COUNT(*)
---------- ----------
         1       4496
         2        715
 

1. 远程机连接数据库的进程数：

netstat -antp |grep ESTABLISHED |awk '{print $5}' |awk -F ':' '{a[$1]++}END{for(i in a)print i,a[i]}'

1. 所有的远程连接，全部被kill

ps -ef|grep -v grep|grep LOCAL=NO|awk '{print $2}'|xargs kill -9