Oracle 修改 processes

来源：互联网发布：js设置disabled属性编辑：程序博客网时间：2024/05/19 15:25
Microsoft Windows [版本 6.1.7601]版权所有 (c) 2009 Microsoft Corporation。保留所有权利。C:\Users\Administrator>sqlplus/ as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on 星期四 11月 30 09:42:39 2017Copyright (c) 1982, 2010, Oracle.  All rights reserved.连接到:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> show parameter processes;NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------aq_tm_processes                      integer     0db_writer_processes                  integer     1gcs_server_processes                 integer     0global_txn_processes                 integer     1job_queue_processes                  integer     1000log_archive_max_processes            integer     4processes                            integer     150SQL>  alter system set processes=1500 scope = spfile;系统已更改。SQL> show parameter processes;NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------aq_tm_processes                      integer     0db_writer_processes                  integer     1gcs_server_processes                 integer     0global_txn_processes                 integer     1job_queue_processes                  integer     1000log_archive_max_processes            integer     4processes                            integer     150SQL> create pfile from spfile;文件已创建。SQL> shutdown immediate;数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。SQL> startupORACLE 例程已经启动。Total System Global Area  855982080 bytesFixed Size                  2180544 bytesVariable Size             608176704 bytesDatabase Buffers          239075328 bytesRedo Buffers                6549504 bytes数据库装载完毕。数据库已经打开。SQL> show parameter processes;NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------aq_tm_processes                      integer     0db_writer_processes                  integer     1gcs_server_processes                 integer     0global_txn_processes                 integer     1job_queue_processes                  integer     1000log_archive_max_processes            integer     4processes                            integer     1500SQL>
阅读全文
0 0