oracle 扩充processes,oracle修改processes参数

oracle修改processes参数以下文字资料是由(历史新知网www.lishixinzhi.com)小编为大家搜集整理后发布的内容，让我们赶快一起来看一下吧！

$ sqlplus / as sysdba

SQL*Plus: Release Production on Thu Nov : :

Copyright (c) Oracle   All Rights Reserved

Connected to:

Oracle Database g Enterprise Edition Release bit Production

With the Partitioning Real Application Clusters OLAP and Data Mining options

SQL> show parameter processes;

NAME                                 TYPE        VALUE

aq_tm_processes                      integer

db_writer_processes                  integer

gcs_server_processes                 integer

job_queue_processes                  integer

log_archive_max_processes            integer

processes                            integer

SQL>

SQL> alter system set processes= scope = spfile;

系统已更改

SQL> show parameter processes;

NAME                                 TYPE        VALUE

aq_tm_processes                      integer

db_writer_processes                  integer

gcs_server_processes                 integer

job_queue_processes                  integer

log_archive_max_processes            integer

processes                            integer

SQL> create pfile from spfile; lishixinzhi/Article/program/Oracle/201311/16505

分页：123