oracle修改程式數

SQL>  alter system  set processes=400 scope=spfile ;

System altered.
SQL> show parameter processes;
      processes                       integer     150
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
重啟
SQL> startup    
ORACLE instance started.
SQL> show parameter processes;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
processes                            integer     400

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/15187685/viewspace-734172/，如需轉載，請註明出處，否則將追究法律責任。