oracle 修改processes参数
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Nov 4 10:43:29 2010
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> show parameter processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 2
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 1000
SQL>
SQL> alter system set processes=1500 scope = spfile;
系统已更改。
SQL> show parameter processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 2
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 1500
SQL> create pfile from spfile;
文件已创建。
本文转自zylhsy 51CTO博客，原文链接：http://blog.51cto.com/yunlongzheng/415068，如需转载请自行联系原作者
