修改processes参数

1、sys登录

$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 21 11:49:58 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

2、查看当前processes，sessions=processes*1.1+5，所以更改processes，sessions自动改变

[@more@]SQL> show parameter processes

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

3、更改参数，scope=spfile说明只改spfile文件，不更改内存，查看v$parameter表可以看出processes参数的更改需要重启数据库才能生效。Alter后查看spfile中已经更改过来，但SQL> show parameter processes仍然显示500

SQL> alter system set processes=1500 scope=spfile;
System altered.

4、创建pfile

SQL> create pfile from spfile;
File created.

5、重启数据库

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 8589934592 bytes
Fixed Size 2034624 bytes
Variable Size 5049943104 bytes
Database Buffers 3523215360 bytes
Redo Buffers 14741504 bytes
Database mounted.
Database opened.

6、查看是否修改成功

SQL> show parameter processes

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 2
gcs_server_processes integer 0
job_queue_processes integer 1
log_archive_max_processes integer 2
processes integer 1500
SQL> show parameter sessions

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
logmnr_max_persistent_sessions integer 1
sessions integer 1655
shared_server_sessions integer

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17254424/viewspace-1059801/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17254424/viewspace-1059801/