My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.