$ 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;
文件已创建
