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 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