ORACLE PARAMETERS ------ _WAIT_FOR_SYNC

SQL> l
  1  select
  2    x.ksppinm  name,
  3    y.ksppstvl  value,
  4    y.ksppstdf  isdefault,
  5    decode(bitand(y.ksppstvf,7),1,'MODIFIED',4,'SYSTEM_MOD','FALSE')  ismod,
  6    decode(bitand(y.ksppstvf,2),2,'TRUE','FALSE')  isadj,
  7    x.ksppdesc describ
  8  from
  9    sys.x$ksppi x,
 10    sys.x$ksppcv y
 11  where
 12    x.inst_id = userenv('Instance') and
 13    y.inst_id = userenv('Instance') and
 14    x.indx = y.indx and
 15    x.ksppinm like '%_&par%'
 16  order by
 17*   translate(x.ksppinm, ' _', ' ')
SQL> /
Enter value for par: wait_for_sync
old  15:   x.ksppinm like '%_&par%'
new  15:   x.ksppinm like '%_wait_for_sync%'

NAME            VALUE      ISDEFAULT ISMOD      ISADJ DESCRIB
--------------- ---------- --------- ---------- ----- --------------------------------------------------
_wait_for_sync  TRUE       TRUE      FALSE      FALSE wait for sync on commit MUST BE ALWAYS TRUE

该参数控制用户commit后是否同步等待日志写入日志文件，默认为true，不建议修改