Lots of "log file sync" waits and nothing else on inserts and commits

I'm really puzzled. Check out the session event stats for my session below.

According to Note 223117.1 from Metalink, if you have a bunch of "log file sync" waits, and not as many "log file parallel write" waits then the problem is not I/O on the redo logs.

In this operation, which is all inserts and commits, we have tons of log file syncs, small cpu (not reflected below, but true) and no log file parallel write waits.

Any ideas?

• Bobby

  1* select event,time_waited from v$session_event where sid=23 SQL> /

EVENT                                                  TIME_WAITED
------------------------------------------------------ -----------
latch                                                            4
free buffer waits                                            10047
buffer busy                                                      5
log buffer space                                             15324
log file switch completion                                     232
log file sync                                               388300
db file sequential read                                       4536
db file scattered read                                        3696
db file parallel read                                            0
direct path read                                                 5
direct path write                                             6067
undo segment extension                                           0
SQL*Net message to client                                       18
SQL*Net message from client                                  59222
SQL*Net more data from client                                  173
SQL*Net break/reset to client                                 1255

16 rows selected. Received on Wed Jan 28 2004 - 15:43:32 CST