Database Processes Are Taking Long Time to Commit

(Doc ID 2402258.1)

Last updated on MAY 30, 2018

Applies to:

Solaris Operating System - Version 10 3/05 HW2 and later
Solaris x64/x86 Operating System - Version 10 3/05 HW1 and later
Information in this document applies to any platform.

Symptoms

Earlier database commit use to happen within fraction of seconds now a large number of database processes appear stuck waiting for their  commit to complete.  Vmstat also shows a large number of thread waiting in biowait ( 'b' column ).

Changes

The host was changed from single path without Veritas to the vx multi pathing

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