SCALABLE LGWR多进程并行写redo log

SCALABLE LGWR主要受到隐藏参数_use_single_log_writer和_max_outstanding_log_writes的控制

_use_single_log_writer参数主要有三个可选值 true,false,adaptive,默认值为adaptive
false,adaptive:如果CPU个数大于一个则会有多个lg0n进程
true:不生成多个lg0n进程，如同12.1之前那样仅有单个LGWR

_max_outstanding_log_writes参数默认值为2

 

SQL>  select a.ksppinm name, b.ksppstvl value, a.ksppdesc description
  2    from x$ksppi a, x$ksppcv b
  3   where a.indx = b.indx and a.ksppinm like '_max_outstanding_log_writes'; 

NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
_max_outstanding_log_writes
2
Maximum number of outstanding redo log writes

[root@19c dbs]# ps -ef |grep ora_lg |grep -v grep
oracle     6100      1  0 19:56 ?        00:00:00 ora_lgwr_orcl19
oracle     6104      1  0 19:56 ?        00:00:00 ora_lg00_orcl19
oracle     6108      1  0 19:56 ?        00:00:00 ora_lg01_orcl19

修改_max_outstanding_log_writes=3

 

 

SQL>  alter system set "_max_outstanding_log_writes"=3 scope=spfile;

[root@19c dbs]# ps -ef |grep ora_lg |grep -v grep
oracle     6789      1  0 20:16 ?        00:00:00 ora_lgwr_orcl19
oracle     6793      1  0 20:16 ?        00:00:00 ora_lg00_orcl19
oracle     6797      1  0 20:16 ?        00:00:00 ora_lg01_orcl19
oracle     6801      1  0 20:16 ?        00:00:00 ora_lg02_orcl19