查看当前最大连接数：
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>
修改最大连接数
SQL> alter system set processes=500 scope = spfile; System altered.
重启数据库使修改生效：
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup; ORACLE instance started. Total System Global Area 4275781632 bytes Fixed Size 2233336 bytes Variable Size 3254782984 bytes Database Buffers 1006632960 bytes Redo Buffers 12132352 bytes Database mounted. Database opened.
