Skip to Main Content

Chinese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Private Strand Flush Not Complete

964975Dec 6 2012 — edited Dec 7 2012
数据库版本: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之后建议使用默认值。

不知道该如何解决这个问题。
请大师们指点一二。
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 4 2013
Added on Dec 6 2012
1 comment
634 views