SQL> show parameter db_writer_processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_writer_processes integer 1
SQL> alter system set db_writer_processes=2 scope=spfile;
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 9787547648 bytes
Fixed Size 2261568 bytes
Variable Size 5402267072 bytes
Database Buffers 4362076160 bytes
Redo Buffers 20942848 bytes
Database mounted.
Database opened.
SQL> show parameter db_writer_processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_writer_processes integer 2
SQL>
oracle修改db_writer_processes
最新推荐文章于 2024-05-14 11:24:22 发布