Thu Aug 03 21:50:10 2017
Thread 1 always the allocate new log, a sequence of 339411
Private strand flush the not complete
Current log# 5 seq# 339410 mem# 0: E: \ \ ADMINISTRATOR \ ORADATA \ APP wouldn \ REDO05 LOG
Thread 1 advanced to log sequence 339411 (LGWR switch)
Current log# 6 seq# 339411 mem# 0: E: \ \ ADMINISTRATOR \ ORADATA \ APP wouldn \ REDO06 LOG
Thu Aug 03 21:54:40 2017
Thread 1 always the allocate new log, a sequence of 339412
Private strand flush the not complete
Current log# 6 seq# 339411 mem# 0: E: \ \ ADMINISTRATOR \ ORADATA \ APP wouldn \ REDO06 LOG
Thread 1 advanced to log sequence 339412 (LGWR switch)
Current log# seq# 339412 mem# 0 1: E: \ \ ADMINISTRATOR \ ORADATA \ APP wouldn \ REDO01 LOG

CodePudding user response:

Log switch are frequent, see redo5, redo6 (the best is to see all of the group) of the two groups of file size, if too small, can be appropriate for larger,

CodePudding user response:

reference 1st floor wmxcn2000 response:

log switch are frequent, see redo5, redo6 (the best is to see all of the group) of the two groups of file size, if too small, can be appropriate for larger,

The original is redo1 redo2 redo3

CodePudding user response:

reference 1st floor wmxcn2000 response:

log switch are frequent, see redo5, redo6 (the best is to see all of the group) of the two groups of file size, if too small, can be appropriate for larger,

Redo4 redo5 redo6 is my new each 200 m