熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

oracle修改processes參數

2013-11-13 12:44:46  來源: Oracle 

  $ 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;

  文件已創建


From:http://tw.wingwit.com/Article/program/Oracle/201311/16505.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.