Hi all!
Just a curiosity: Have you ever noticed in a database alert log the occourance of the following message for every logfile switch:
Thread 1 cannot allocate new log, sequence 9281 Private strand flush not complete Current log# 5 seq# 9280 mem# 0: /db/u5001/oradata/GREPORADB/redo05a.log Thread 1 advanced to log sequence 9281 (LGWR switch) Current log# 6 seq# 9281 mem# 0: /db/u5001/oradata/GREPORADB/redo06a.log
More“Alert Log: “Private Strand Flush Not Complete” on Logfile Switch”