Skip to Main Content

Oracle Database Discussions

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!

log file sync?

71981Feb 28 2008 — edited Mar 13 2008
Waits on event "log file sync" while performing COMMIT and ROLLBACK operations were consuming significant database time.
Wait class "Commit" was consuming significant database time.

This message comes out when we run ADDM on an instance we are trying to run an import of a large database schema into. It is taking forever...

We are on a HPUX and using ASM for all datafiles, logs etc.

I look at the disk group for the ASM instance and see nothing unusual and no alerts.

the recommendation is to "Investigate the possibility of improving the performance of I/O to the online redo log files."

but if ASM managing these redo logs, how do we "improve the performance of I/O to the online redo log files.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 10 2008
Added on Feb 28 2008
19 comments
4,096 views