oracle 扩充processes,oracle 修改processes参数

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;

文件已创建。