Community

User Commits, Log File Parallel Write and Log File Sync

(Andrew Reid) I ran this example on Oracle 11.2. If an application spends too much time waiting on log file parallel write and/or log file sync, it may be doing too many user commits. To illustrate this, I created the SQL*Plus script below.

Read More - Register for Free Membership

Tags: