This content has been marked as final. Show 5 replies
More frequent COMMITs cause this wait to appear.
Does disconnecting a number of connections (connection pool) have something to do with "log file sync"?If your disconnection also reducese number of concurrent sessions and transactions and eventually number of commits, then yes, it can effect the frequence of this wait event.
At the time of dis-connecting a number of connections, there was no rapid increase in "user commits".You can check this by running the query before and after disconnection:
Does Oracle do a number of "recursive commit" during dis-connection which is not counted for "user commit"?
select name, value from v$sysstat where name like '%commit%';