This discussion is archived
1 Reply Latest reply: Dec 7, 2012 5:46 AM by LiuMaclean(刘相兵) RSS

Private Strand Flush Not Complete

964975 Newbie
Currently Being Moderated
数据库版本:oracle 11.2.0.3


alert中出现以下信息,日志中几乎每个sequence都是如此:
Thread 1 cannot allocate new log, sequence 1169
Thread 1 advanced to log sequence 1170 (LGWR switch)


SQL> show parameter db_write

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_writer_processes integer 1



MOS :Private Strand Flush Not Complete [ID 372557.1]
建议加大db_writer_processes ,但有很多人说10gR2之后建议使用默认值。

不知道该如何解决这个问题。
请大师们指点一二。

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points