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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Log file sync wait events due to commit or I/O -12.2 Rac database

VimalshuMay 10 2020 — edited May 15 2020

Hi All,

I have observed log file sync wait events in my rac database but not sure whether it is because of high number of commit or due to i/o issue (log file parallel wait,attached histogram as well).

DB version -12.2.0.1.0 - 64bit

Redo log file size-4GB.

Storage Details:

ZFS appliance Storage.

HBA = 2-port 16Gb FC HBA

Disks = 1.2 TB 10K RPM

Switch = 10Gbps

Below is awr screenshot from node 1.

ScreenHunter_31 May. 10 10.36.jpg ScreenHunter_32 May. 10 10.37.jpg