High Log File Sync Wait Due to LGWR with Slow io_submit()

(Doc ID 2400987.1)

Last updated on JUNE 07, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Red Hat Advanced Server

Symptoms

 To get the errorrstack of LGWR, you may refer the doc below.  Both actions should be taken while the issue is happening..

How to Collect Errorstacks for use in Diagnosing Performance Issues. (Doc ID 1364257.1)
Steps to generate HANGANALYZE trace files (9i and below) (Doc ID 175006.1)

Changes

DB server has been moved to other data center.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms