Ways to reduce log file sync Oracle?

Question

Oracle

Colleagues, good day!
It so happened that, on duty, I ran into a bunch of apache2 + oracle.
Everything was going well and just fine, but in the last month, oracle began to slow down significantly, the response and commit times increased.

Event             							                        Waits			                      Time(s)			                       Avg wait (ms)		             % DB time	             Wait Class
log file sync					                           196,449                  77,420                       			394                       					      97.25                     		Commit

Perhaps someone can suggest a way to solve the problem?

Answer 1

Hardly there apache goes to Oracle, not? Probably there is some kind of software written by krivoruk developers in php? And each click on the page generates hundreds of queries in the database. Check whether commits are being made after each insert/update, well, look at iostat/vmstat, what's with the disks? Can change to ssd or a fast disk array.

Answer 2

Metalink Troubleshooting: "log file sync" Waits (Doc ID 1376916.1)